| Lists: | pgsql-general |
|---|
| From: | <gnuoytr(at)rcn(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | tgname munged |
| Date: | 2010-08-04 15:30:21 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
Can anyone explain why the following query (used by AQT to display its tree):
SELECT trig.tgname,
tab.relname,
case trig.tgenabled
when '1' then 'yes'
else 'no'
end,
trig.oid
FROM pg_catalog.pg_trigger trig,
pg_catalog.pg_class tab,
pg_catalog.pg_namespace nam
WHERE trig.tgrelid=tab.oid
AND tab.relnamespace=nam.oid
AND nam.nspname ='public' -- ?
ORDER BY 1
produces tgname like (from memory) RIFKConstraint...<number>
while without the ORDER BY (and it doesn't matter how you identify the column) tgname displays correctly (well, the same as what you see if you SELECT * FROM pg_trigger).
thanks,
Robert
| From: | "Stéphane A(dot) Schildknecht" <stephane(dot)schildknecht(at)postgresql(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tgname munged |
| Date: | 2010-08-04 15:57:47 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Le 04/08/2010 17:30, gnuoytr(at)rcn(dot)com a écrit :
> Can anyone explain why the following query (used by AQT to display its tree):
>
> SELECT trig.tgname,
> tab.relname,
> case trig.tgenabled
> when '1' then 'yes'
> else 'no'
> end,
> trig.oid
> FROM pg_catalog.pg_trigger trig,
> pg_catalog.pg_class tab,
> pg_catalog.pg_namespace nam
> WHERE trig.tgrelid=tab.oid
> AND tab.relnamespace=nam.oid
> AND nam.nspname ='public' -- ?
> ORDER BY 1
>
> produces tgname like (from memory) RIFKConstraint...<number>
> while without the ORDER BY (and it doesn't matter how you identify the column) tgname displays correctly (well, the same as what you see if you SELECT * FROM pg_trigger).
>
Hi,
Which version of PostgreSQL is it ?
I can't see any difference with PG 8.4.4.
Regards,
- --
Stéphane Schildknecht
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkxZjfsACgkQA+REPKWGI0HiMQCfWf54uFM3WMy3LsxQ+513J1il
ETsAoLD23uOijdlwOR7X4av+n9pmSi02
=eOIx
-----END PGP SIGNATURE-----