Hi,
Svetlana, yes, Tom means that CREATE OR REPLACE should always produce
the same result no matter which branch actually worked - CREATE or REPLACE.
REPLACE case must produce exactly the same result as you've mentioned -
DROP and CREATE.
As for IF NOT EXISTS option I agree, it seems a reasonable
>Вторник, 5 июля 2022, 18:29 +03:00 от Tom Lane :
>
>=?UTF-8?B?U3ZldGxhbmEgRGVyZXZ5YW5rbw==?= < s.derevya...@postgrespro.ru >
>writes:
>> 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