[PATCH] Optional OR REPLACE in CREATE OPERATOR statement

Svetlana Derevyanko <s.derevyanko@postgrespro.ru>

From: Svetlana Derevyanko <s.derevyanko@postgrespro.ru>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-07-05T08:40:23Z
Lists: pgsql-hackers

Attachments

 
Hello hackers,
 
It seems useful to have [OR REPLACE] option in CREATE OPERATOR statement, as in CREATE FUNCTION. This option may be good for writing extension update scripts, to avoid errors with re-creating the same operator.
 
Because of cached query plans, only RESTRICT and JOIN options can be changed for existing operator, as in ALTER OPERATOR statement.
(discussed here:  https://www.postgresql.org/message-id/flat/3348985.V7xMLFDaJO%40dinodell )
 
The attached patch will be proposed for September CF.
 
Best regards,
--
Svetlana Derevyanko
Postgres Professional:  http://www.postgrespro.com
The Russian Postgres Company