Обсуждение: Trigger Blunder
I had smoe truggers I wanted to get rid of - instead of doing a DROP TRIGGER sql command, I deleted the trigger records from the pg_trigger table.... it was late.... i don't know what I was thinking! Anyhow - now when I try to delete anything from these tables, or delete the tables themself I get the message: RelationBuildTriggers: 1 record(s) not found for rel tablename Any suggestions on how I can deal with this other than recreating the entire DB? Or restoring from backup? Thanks Ryan Mahoney
ryan@paymentalliane.net writes: > I had smoe truggers I wanted to get rid of - instead of doing a DROP > TRIGGER sql command, I deleted the trigger records from the pg_trigger > table.... it was late.... i don't know what I was thinking! > Anyhow - now when I try to delete anything from these tables, or > delete the tables themself I get the message: > RelationBuildTriggers: 1 record(s) not found for rel tablename Reset the "reltriggers" count (field in pg_class) to zero for each affected table. regards, tom lane
Tom Lane wrote: > ryan@paymentalliane.net writes: > > I had smoe truggers I wanted to get rid of - instead of doing a DROP > > TRIGGER sql command, I deleted the trigger records from the pg_trigger > > table.... it was late.... i don't know what I was thinking! > > > Anyhow - now when I try to delete anything from these tables, or > > delete the tables themself I get the message: > > > RelationBuildTriggers: 1 record(s) not found for rel tablename > > Reset the "reltriggers" count (field in pg_class) to zero for each > affected table. Better reset it to the number of triggers that remained on each class. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com