From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: at@mtc.md
Subject: CREATE TRIGGER documentation inconsistensies
Date: Thu, 24 Aug 2023 07:50:54 +0000
Message-ID: <169286345424.621.8832808856493079834@wrigleys.postgresql.org> (raw)
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.
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: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, at@mtc.md
Subject: Re: CREATE TRIGGER documentation inconsistensies
In-Reply-To: <169286345424.621.8832808856493079834@wrigleys.postgresql.org>
* 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