Re: Re: How to drop an trigger - Mailing list pgsql-sql

From Tom Lane
Subject Re: Re: How to drop an trigger
Date
Msg-id 28010.984073833@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: How to drop an trigger  (Frank Joerdens <frank@joerdens.de>)
List pgsql-sql
Frank Joerdens <frank@joerdens.de> writes:
>> Just an idea: Is it safe to just delete the corresponding row in
>> pg_trigger?

> No, it ain't: After deleting the rows corresponding to the offending
> triggers in pg_trigger, I can't vacuum, or dump.

You need to adjust the reltriggers counts in the associated pg_class
entries, too.
        regards, tom lane


pgsql-sql by date:

Previous
From: Christof Glaser
Date:
Subject: Re: How to build this field
Next
From: dev@archonet.com
Date:
Subject: Re: Writing SQL functions in Postgres