Request a Demo
Home   >   mailing lists

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

From Tom Lane
Subject Re: Patch: create or replace language
Date
Msg-id [email protected]
Whole thread Raw
In response to Patch: create or replace language  (Andreas 'ads' Scherbaum <[email protected]>)
Responses Re: Patch: create or replace language
List pgsql-hackers
Tree view 
"Andreas 'ads' Scherbaum" <[email protected]> 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