Horton
Menu

Re: CREATE SCHEMA IF NOT EXISTS

Fabrízio de Royes Mello <fabriziomello@gmail.com>

View thread
From: Fabrízio de Royes Mello <fabriziomello@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>, "David E. Wheeler" <david@justatheory.com>, "Dickson S. Guedes" <listas@guedesoft.net>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-10-03T13:11:03Z
Lists: pgsql-hackers 
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
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Document the lack of reading the PGDATABASE environment variable in