[PATCH] Optional OR REPLACE in CREATE OPERATOR statement

 

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