Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE SCHEMA IF NOT EXISTS - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: CREATE SCHEMA IF NOT EXISTS
Date
Msg-id CAFcNs+qMMK83icUbH=+5NBYfSUR6pUcXUBWzrAtzBZsdweZmyA@mail.gmail.com
Whole thread Raw
In response to Re: CREATE SCHEMA IF NOT EXISTS  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: CREATE SCHEMA IF NOT EXISTS  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view

2012/10/3 Alvaro Herrera <alvherre@2ndquadrant.com>
Excerpts from Fabrízio de Royes Mello's message of mié oct 03 09:27:41 -0300 2012:
> 2012/10/2 Fabrízio de Royes Mello <fabriziomello@gmail.com>
>
> >
> > You're right... the latest proposed patch don't implements it.
> >
> > I'll change the patch and send soon...
> >
> >
> What is more reasonable?
> * show a syntax error or
> * show a message that you can not use the INE with contained objects

Second one.


Maybe something like this?

   ereport(ERROR,
           (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
            errmsg("IF NOT EXISTS cannot be used with schema elements"),
            parser_errposition(@9)));


--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: CREATE SCHEMA IF NOT EXISTS
Next
From: Tom Lane
Date:
Subject: Re: Support for REINDEX CONCURRENTLY