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
---<<(())>>---
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 |