From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | at(at)mtc(dot)md, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: CREATE TRIGGER documentation inconsistensies |
Date: | 2023-08-24 09:27:46 |
Message-ID: | 890483629.390853.1692869266420@office.mailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
> On 24/08/2023 09:50 CEST PG Doc comments form <noreply(at)postgresql(dot)org> wrote:
>
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/sql-createtrigger.html
> Description:
>
> In PostgreSQL 14 and 15 (previous versions I've not checked) is stated that
> CREATE TRIGGER statement is as follows:
>
> CREATE [OR REPLACE] [CONSTRAINT] TRIGGER
>
> however while CREATE TRIGGER works correctly the CREATE OR REPLACE TRIGGER
> construction leads to
>
> SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "TRIGGER"
>
> looks like CREATE TRIGGER doesn't support OR REPLACE, but documentation is
> then incorrect.
Works for me on 14.9 and 15.4:
BEGIN;
CREATE TABLE mytbl (f1 int);
CREATE FUNCTION mytrigger()
RETURNS trigger
LANGUAGE plpgsql
AS $$ BEGIN RETURN null; END $$;
CREATE OR REPLACE TRIGGER mytrig
BEFORE INSERT
ON mytbl
EXECUTE FUNCTION mytrigger();
COMMIT;
CREATE OR REPLACE TRIGGER was added in 14. Did you test on an older version?
--
Erik
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Tihonovschi | 2023-08-25 18:09:35 | Re: CREATE TRIGGER documentation inconsistensies |
Previous Message | PG Doc comments form | 2023-08-24 07:50:54 | CREATE TRIGGER documentation inconsistensies |