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 (view raw or flat )
Thread:
2012-08-15 17:50:00 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-08-15 18:31:27 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-15 20:10:43 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-08-16 17:36:32 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-16 17:43:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-08-16 17:49:43 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-08-16 17:55:03 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-17 00:44:22 from "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
2012-08-17 13:16:30 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-17 13:42:26 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-17 13:46:17 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-08-17 13:59:58 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-17 14:37:25 from "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
2012-08-17 21:22:16 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-28 02:01:19 from "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
2012-08-28 15:19:40 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-08-28 16:08:13 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-08-28 16:29:08 from "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
2012-09-21 17:59:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-09-21 18:06:25 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-09-21 23:59:07 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-09-22 05:13:10 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-09-29 09:32:13 from Volker Grabsch <vog(at)notjusthosting(dot)com>
2012-10-02 19:14:29 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 19:08:16 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 19:16:37 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-10-02 19:30:05 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 19:37:30 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-10-02 19:52:15 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 19:48:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-10-02 19:54:21 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
2012-10-02 20:24:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-10-02 20:38:20 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-02 22:33:17 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-10-02 22:58:12 from Stirling Newberry <stirling(dot)newberry(at)xigenics(dot)net>
2012-10-03 12:27:41 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-10-03 12:55:37 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-03 13:11:03 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-10-03 16:07:38 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-03 17:29:38 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-10-03 17:56:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-10-03 23:49:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-10-04 00:17:10 from "David E(dot) Wheeler" <david(at)justatheory(dot)com>
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
pgsql-hackers by date
Next :From: Tom LaneDate: 2012-10-03 14:28:59Subject : Re: Support for REINDEX CONCURRENTLYPrevious :From : Alvaro HerreraDate : 2012-10-03 12:55:37Subject : Re: CREATE SCHEMA IF NOT EXISTS
