From: | Jan Wieck <janwieck(at)Yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | ryan(at)paymentalliane(dot)net, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Trigger Blunder |
Date: | 2001-03-03 09:40:53 |
Message-ID: | 200103030940.EAA04454@jupiter.jw.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> ryan(at)paymentalliane(dot)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(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-03-03 10:31:51 | Re: Can you list the text of a proc in psql? |
Previous Message | Jonny Deng | 2001-03-03 06:21:00 | Re: Re: Want to learn the Postgresql database system |