Re: problem with 'DROP TABLE' ..

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 mallah(at)trade-india(dot)com 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/