Обсуждение: 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