Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements - Mailing list pgsql-hackers

On Wed, 2013-06-12 at 16:31 -0300, Fabrízio de Royes Mello wrote:
> > Btw., I also want REPLACE BUT DO NOT CREATE.
> 
> Can you explain more about it?
> 
Replace/alter the object if it already exists, but fail if it does not
exist.

The complete set of variants is:

- object does not exist:
   - proceed (normal CREATE)   - error (my above description)

- object exists:
   - replace (CREATE OR REPLACE)   - skip (CREATE IF NOT EXISTS)   - error (normal CREATE)