Re: CREATE SCHEMA IF NOT EXISTS

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David E(dot) Wheeler" <david(at)justatheory(dot)com>, "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE SCHEMA IF NOT EXISTS
Date: 2012-10-03 13:11:03
Message-ID: CAFcNs+qMMK83icUbH=+5NBYfSUR6pUcXUBWzrAtzBZsdweZmyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2012/10/3 Alvaro Herrera <alvherre(at)2ndquadrant(dot)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(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-10-03 14:28:59 Re: Support for REINDEX CONCURRENTLY
Previous Message Alvaro Herrera 2012-10-03 12:55:37 Re: CREATE SCHEMA IF NOT EXISTS