dbTalk Databases Forums  

[BUGS] BUG #2157: Disabling trigger

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2157: Disabling trigger in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jiri Klepac
 
Posts: n/a

Default [BUGS] BUG #2157: Disabling trigger - 01-09-2006 , 02:23 PM







The following bug has been logged online:

Bug reference: 2157
Logged by: Jiri Klepac
Email address: goofy (AT) post (DOT) 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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #2  
Old   
Michael Fuhr
 
Posts: n/a

Default Re: [BUGS] BUG #2157: Disabling trigger - 01-09-2006 , 02:38 PM






On Mon, Jan 09, 2006 at 03:35:47PM +0000, Jiri Klepac wrote:
Quote:
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/i...ltertable.html
http://www.postgresql.org/docs/8.1/i...ltertable.html

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.