CREATE TRIGGER documentation inconsistensies

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: at(at)mtc(dot)md
Subject: CREATE TRIGGER documentation inconsistensies
Date: 2023-08-24 07:50:54
Message-ID: 169286345424.621.8832808856493079834@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Erik Wienhold 2023-08-24 09:27:46 Re: CREATE TRIGGER documentation inconsistensies
Previous Message Euler Taveira 2023-08-23 18:31:04 Re: There is no description about "Logical Replication also use or occupy max_wal_senders ",