[BUGS] BUG #2157: Disabling trigger
The following bug has been logged online: Bug reference: 2157 Logged by: Jiri Klepac Email address: [EMAIL PROTECTED] 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. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] BUG #2157: Disabling trigger
On Mon, Jan 09, 2006 at 03:35:47PM +, 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
