Re: CREATE SCHEMA IF NOT EXISTS
From:
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:
Volker Grabsch <vog(at)notjusthosting(dot)com>
Cc:
Dickson S(dot) Guedes <listas(at)guedesoft(dot)net>, fabriziomello <fabriziomello(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, david <david(at)justatheory(dot)com>
Subject:
Re: CREATE SCHEMA IF NOT EXISTS
Date:
2012-10-02 19:14:29
Message-ID:
1349204899-sup-5876@alvh.no-ip.org (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
Excerpts from Volker Grabsch's message of sáb sep 29 06:32:13 -0300 2012:
> Dickson S. Guedes schrieb:
> > - https://commitfest.postgresql.org/action/patch_view?id=907
> >
> > The patch is small and implements a new syntax to CREATE SCHEMA
> > that allow the creation of a schema be skipped when IF NOT EXISTS is
> > used.
> >
> > [...]
> >
> > - Should this patch implements others INEs like ADD COLUMN IF NOT EXISTS?
>
> If there's still a chance to improve the patch, I'd love to see
> the following INEs implemented. Several real-world database
> upgrade scripts would benefit from those:
I don't see that this patch is responsible for such new commands. If
you want them, feel free to submit separate patches for them (or have
someone else do it for you). But see the thread starting at
http://archives.postgresql.org/message-id/467881.79137.qm%40web27104.mail.ukl.yahoo.com
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
In response to
pgsql-hackers by date
Next :From: David JohnstonDate: 2012-10-02 19:15:49Subject : Re: Raise a WARNING if a REVOKE affects nothing?Previous :From : Peter GeogheganDate : 2012-10-02 19:09:35Subject : Re: Hash id in pg_stat_statements
