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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-hackers by date

  From Date Subject
Next Message David Johnston 2012-10-02 19:15:49 Re: Raise a WARNING if a REVOKE affects nothing?
Previous Message Peter Geoghegan 2012-10-02 19:09:35 Re: Hash id in pg_stat_statements