Re: CREATE SCHEMA IF NOT EXISTS

From: Volker Grabsch <vog(at)notjusthosting(dot)com>
To: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
Cc: fabriziomello(at)gmail(dot)com, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, david(at)justatheory(dot)com
Subject: Re: CREATE SCHEMA IF NOT EXISTS
Date: 2012-09-29 09:32:13
Message-ID: 20120929093213.GE16144@vlap
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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:

1)
CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] name ...

2)
ALTER TABLE ... ADD [ COLUMN ] [ IF NOT EXISTS ] column_name ...

3)
CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ IF NOT EXISTS ] [ name ] ON ...

Regards,
Volker

--
Volker Grabsch
---<<(())>>---

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dariel Nicolas De Jesus Medrnao 2012-09-29 12:53:31 Installation of xpath (read xml on postgres)
Previous Message Misa Simic 2012-09-29 07:49:56 Re: data to json enhancements