-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Fri, 25 Mar 2005, Tom Lane wrote:
> Devrim GUNDUZ <devrim@gunduz.org> writes:
>> prod=# select * from pg_trigger where tgname = 'RI_ConstraintTrigger_39053';
>> - -[ RECORD 1 ]--+---------------------------
>> tgrelid | 37564
>> tgname | RI_ConstraintTrigger_39053
>> tgfoid | 1644
>> tgtype | 21
>> tgenabled | t
>> tgisconstraint | t
>> tgconstrname | firma_moduller_firma_fkey1
>> tgconstrrelid | 37577
>> tgdeferrable | f
>> tginitdeferred | f
>> tgnargs | 6
>> tgattr |
>> tgargs | firma_moduller_firma_fkey1
>
> Well, that's consistent with what pg_dump said the tgargs value is;
> but it ought to look like
> firma_moduller_firma_fkey1\000t_firma_moduller\000t_firmalar\000UNSPECIFIED\000firma_no\000no\000
> and the output from \d proves that that data is actually stored. So why
> isn't it being displayed??
>
> Does "\d pg_trigger" show that the tgargs column is of type bytea?
Umm no:
tgnargs | smallint | not null
> Also, get the OID for this pg_trigger row and see if it shows up in
> objid or refobjid of any rows of pg_depend
Yes it is there
prod=# SELECT * from pg_depend WHERE objid =39053;
- -[ RECORD 1 ]------
classid | 16412
objid | 39053
objsubid | 0
refclassid | 1259
refobjid | 37564
refobjsubid | 0
deptype | a
- -[ RECORD 2 ]------
classid | 16412
objid | 39053
objsubid | 0
refclassid | 1259
refobjid | 37577
refobjsubid | 0
deptype | a
So... Is it with tgnargs issue? :(
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFCRFYUtl86P3SPfQ4RAk1LAJ4wW13o7n29Fr52SY5/EbqNysh3PACgznyh
6RLdbTufPwP+vuHXc3+h1WE=
=AOBb
-----END PGP SIGNATURE-----