[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
- v1-0001-Add-optional-OR-REPLACE-in-CREATE-OPERATOR-statem.patch (text/x-diff) patch v1-0001
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