Horton

RE: extension patch of CREATE OR REPLACE TRIGGER

Takamichi Osumi (Fujitsu) <osumi.takamichi@fujitsu.com>

View thread View on postgr.es
From: "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
To: 'Peter Smith' <smithpb2250@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Michael Paquier <michael@paquier.xyz>, Thomas Munro <thomas.munro@gmail.com>, Surafel Temesgen <surafel3000@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-08-24T11:33:31Z
Lists: pgsql-hackers

Attachments

Hi,

Thanks, Peter.
> FYI - The latest patch (v06) has conflicts when applied.

I've fixed my v06 and created v07.
Also, I added one test to throw an error
to avoid a situation that trigger which has pending events are replaced by
any other trigger in the same session.

Best,
	Takamichi Osumi

Commits

  1. Provide the OR REPLACE option for CREATE TRIGGER.