Re: CREATE SCHEMA IF NOT EXISTS - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: CREATE SCHEMA IF NOT EXISTS
Date
Msg-id 1349204899-sup-5876@alvh.no-ip.org
Whole thread Raw
In response to Re: CREATE SCHEMA IF NOT EXISTS  (Volker Grabsch <vog@notjusthosting.com>)
List 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



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Hash id in pg_stat_statements
Next
From: "David Johnston"
Date:
Subject: Re: Raise a WARNING if a REVOKE affects nothing?