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-09-10T02:34:25Z
Lists: pgsql-hackers

Attachments

Hello, Peter-San


> > That's a great idea. I've applied this idea to the latest patch v10.
> 
> ====
> 
> COMMENT create_trigger.sgml (typo/wording)
> 
> "vise versa" -> "vice versa"
Sorry and thank you for all your pointing out.

> BEFORE
> You cannot replace triggers with a different type of trigger, that means it is
> impossible to replace regular trigger with constraint trigger and vise versa.
> 
> AFTER (suggestion)
> You cannot replace triggers with a different type of trigger. That means it is
> impossible to replace a regular trigger with a constraint trigger, and vice versa.
Thank you. Your suggestion must be better.

I attached the v11 patch.

Regards,
	Takamichi Osumi

Commits

  1. Provide the OR REPLACE option for CREATE TRIGGER.