pg_dump issue : Cannot drop a non-existent(?) trigger

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I've Google'd for the situation below and could not find any solution.

We are using PostgreSQL 8.0.1, installed using PGDG RPMs on RHEL ES 3.0:

=======================================================================
prod=# SELECT version();
version
- --------------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.1 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.2.3 20030502 (Red Hat Linux 3.2.3-42)
=======================================================================

We wanted to take a full backup, so ran pg_dump,but got an error:

=======================================================================
$ pg_dump prod -U postgres > all.pgdump
pg_dump: invalid argument string (firma_moduller_firma_fkey1) for trigger
"RI_ConstraintTrigger_39053" on table "t_firma_moduller"
=======================================================================

Looking at the details, we saw the trigger there:

=======================================================================
prod=# \d t_firma_moduller
Table
"public.t_firma_moduller"
Column | Type |
Modifiers
- ------------------+-----------------------------+--------------------------------------------------------------------------
firma_no | character varying(10) | not null
modul_adi | character varying(20) | not null
last_update_date | timestamp without time zone |
last_update_user | character varying(45) |
kod | integer | not null default
fn_get_seq_value('t_firma_moduller'::character varying)
Indexes:
"t_firma_moduller_pkey" PRIMARY KEY, btree (firma_no, modul_adi)
"t_firma_moduller_kodu_ukey" UNIQUE, btree (kod)
Triggers:
"RI_ConstraintTrigger_39053" AFTER INSERT OR UPDATE ON
t_firma_moduller FROM t_firmalar NOT DEFERRABLE INITIALLY IMMEDIATE FOR
EACH ROW EXECUTE PROCEDURE
"RI_FKey_check_ins"('firma_moduller_firma_fkey1', 't_firma_moduller',
't_firmalar', 'UNSPECIFIED', 'firma_no', 'no')
Tablespace: "data_ts"
=======================================================================

However, pgadmin3 can't see that. That is more possible since we can't
drop them:

prod=# DROP TRIGGER RI_ConstraintTrigger_39053 ON t_firma_moduller;
ERROR: trigger "ri_constrainttrigger_39053" for table "t_firma_moduller"
does not exist

Is this a bug or something? There should not be a trigger there.

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)

iD8DBQFCQ+17tl86P3SPfQ4RAhZKAKCTEzLTizwyt+Zomgv3ikiussyaSQCgtDdD
Q3Ua6lJChMT43p2x+bo0rPY=
=s4g2
-----END PGP SIGNATURE-----