-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
On Fri, 25 Mar 2005, Tom Lane wrote:
Devrim GUNDUZ <[EMAIL PROTECTED]> 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-----
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
