Re: Does trigger only accept functions? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Does trigger only accept functions?
Date
Msg-id 3ccbf6ee561bd9435115101140b654d0961e5f13.camel@cybertec.at
Whole thread Raw
In response to Re: Does trigger only accept functions?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Mon, 2024-06-10 at 13:20 -0700, Adrian Klaver wrote:
> https://www.postgresql.org/docs/15/sql-createtrigger.html
>
> That is either a function or a procedure.

The trigger function must be a function, it cannot be a procedure.
The syntax EXECUTE PROCEDURE is just for backward compatibility with
the time before PostgreSQL had procedures.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Gaps in PK sequence numbers [RESOLVED]
Next
From: Kashif Zeeshan
Date:
Subject: Re: Vacuum backend with backend_xmin?