Re: Patch: create or replace language - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Patch: create or replace language
Date
Msg-id 917.1254838434@sss.pgh.pa.us
Whole thread Raw
In response to Patch: create or replace language  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Responses Re: Patch: create or replace language
List pgsql-hackers
"Andreas 'ads' Scherbaum" <adsmail@wars-nicht.de> writes:
> following this old discussion:
> http://archives.postgresql.org/pgsql-patches/2008-03/msg00402.php
> i modifies the patch to use the "CREATE [OR REPLACE] LANGUAGE" syntax.

This is not an "OR REPLACE" operation, because it doesn't replace
the existing definition.  What you've got here is a CREATE IF NOT EXISTS
implementation that arbitrarily uses the other syntax.  The point of
the previous discussion was summed up here:
http://archives.postgresql.org/pgsql-patches/2008-03/msg00416.php
namely that CREATE OR REPLACE should leave the object having the
properties specified in the command.
        regards, tom lane


pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: [PATCH] DefaultACLs
Next
From: Alvaro Herrera
Date:
Subject: Re: Patch: create or replace language