Thread: BUG #2157: Disabling trigger

The following bug has been logged online:

Bug reference:      2157
Logged by:          Jiri Klepac
Email address:      goofy@post.cz
PostgreSQL version: 8.0
Operating system:   win2000
Description:        Disabling trigger
Details:

I was tryiing to disable trigger for specific table. ALTER TABLE tbl DISABLE
TRIGGER trg_name;
This is well documented in manual for ALTER TABLE command. But database
answered: ERROR:  syntax error at or near "DISABLE" at character 32. It even
don't know DISABLE as a key word.

Kind regards, Jiri Klepac.

On Mon, Jan 09, 2006 at 03:35:47PM +0000, Jiri Klepac wrote:
> I was tryiing to disable trigger for specific table. ALTER TABLE tbl DISABLE
> TRIGGER trg_name;
> This is well documented in manual for ALTER TABLE command.

Are you sure you're looking at the documentation for the version
you're running?  DISABLE TRIGGER is in the documentation for 8.1
but not for 8.0.

http://www.postgresql.org/docs/8.0/interactive/sql-altertable.html
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html

--
Michael Fuhr