yep there is a mismatch . shud i delete the entries from pg_trigger to match reltriggers i am sure i dont' need those triggers.
regds mallah. tradein_clients=# SELECT relfilenode,relkind,reltriggers from pg_class where relname='branding_master'; relfilenode | relkind | reltriggers -------------+---------+------------- 46979870 | r | 0 48724633 | v | 0 (2 rows) tradein_clients=# SELECT count(*) from pg_trigger where tgrelid=46979870; count ------- 9 (1 row) tradein_clients=# > > On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote: > >> >> Hi , >> >> i get following error when attempting to drop a table. >> >> tradein_clients=# DROP TABLE branding_master; >> ERROR: DropTrigger: relation branding_nob_bak has reltriggers = 0 tradein_clients=# > > Did you make any direct changes to the pg_class row or to the pg_triggers rows >associated with > this table? ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org