From: Andrei Tihonovschi <at@mtc.md>
To: Erik Wienhold <ewie@ewie.name>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: CREATE TRIGGER documentation inconsistensies
Date: Fri, 25 Aug 2023 21:09:35 +0300 (GMT+03:00)
Message-ID: <25461b1e.1692986931408@imap.mtc.md> (raw)
References: <169286345424.621.8832808856493079834@wrigleys.postgresql.org>
<890483629.390853.1692869266420@office.mailbox.org>
Thanks for clarifying, Erik.
That was my fault. I was absolutely sure I've upgraded PostgreSQL to v.14 but actually I've had v.13 running.
After upgrading to v.14 the CREATE OR REPLACE TRIGGER construction works as it was stated in the documentation.
Thanks again.
Sent by from my Android device.
24 августа 2023 г., 12:27, Erik Wienhold написал (-а):
On 24/08/2023 09:50 CEST PG Doc comments form <noreply@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: at@mtc.md, ewie@ewie.name, pgsql-docs@lists.postgresql.org
Subject: Re: CREATE TRIGGER documentation inconsistensies
In-Reply-To: <25461b1e.1692986931408@imap.mtc.md>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox