Обсуждение: problem with "DROP TABLE" ..
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=# can anyone suggest what might be the problem? regds mallah. ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
On Sat, 15 Feb 2003 mallah@trade-india.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?
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@trade-india.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/
On Sat, 15 Feb 2003 mallah@trade-india.com wrote: > yep there is a mismatch . > shud i delete the entries from pg_trigger to match reltriggers > i am sure i dont' need those triggers. Hmm, I was going to just say yes, but then realized that if any of those are foreign key triggers, you'll need to drop both the triggers on this table and the associated triggers on the other table(s).
yes maybe. thanks for the help. regds mallah. > > On Sat, 15 Feb 2003 mallah@trade-india.com wrote: > >> yep there is a mismatch . >> shud i delete the entries from pg_trigger to match reltriggers >> i am sure i dont' need those triggers. > > Hmm, I was going to just say yes, but then realized that if any > of those are foreign key triggers, you'll need to drop both the > triggers on this table and the associated triggers on the other > table(s). ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/