From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_dump issue : Cannot drop a non-existent(?) trigger |
Date: | 2005-03-26 10:14:28 |
Message-ID: | Pine.LNX.4.61.0503260921450.4326@emo.org.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Fri, 25 Mar 2005, Tom Lane wrote:
>>> Does "\d pg_trigger" show that the tgargs column is of type bytea?
>
>> Umm no:
>
>> tgnargs | smallint | not null
>
> tgargs, not tgnargs.
Ooops, sorry. Ok, tgargs is of type bytea.
>>> 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
>
> Hmph. Those should be 'i' references to the foreign key constraint,
> not 'a' references to the relations. I suspect this database was
> carried forward from an ancient (pre-7.3) dump that defined the triggers
> by "CREATE CONSTRAINT TRIGGER" instead of "ALTER ADD FOREIGN KEY".
I haven't coded the application but AFAIKit was developed using 7.4 and
7.5(CVS); and we installed database on 8.0.1... This is a new app.
As a reminder, we ran pg_dump successfully before. After then we did
nothing on schemas, we didn't upgrade db server, etc.
> Have you ever run contrib/adddepend to update the definitions to be
> proper constraints?
Now I did, but the found constraints are not related to our problem... :(
I'll try to drop trigger on Monday night and see what will happen. We have
no up2date backup, except WAL logs... :(
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)
iD8DBQFCRTYGtl86P3SPfQ4RAjn7AKDrz+t6gsc53EAQ9UZAfAmgpZUwVACg532w
7c61IvIL5e2AjRg+5jV1BVw=
=Um2T
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2005-03-26 10:41:38 | understanding pg_stat* numbers |
Previous Message | Tom Lane | 2005-03-26 07:30:28 | Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was |