Re: CREATE SCHEMA IF NOT EXISTS
От | Volker Grabsch |
---|---|
Тема | Re: CREATE SCHEMA IF NOT EXISTS |
Дата | |
Msg-id | 20120929093213.GE16144@vlap обсуждение исходный текст |
Ответ на | Re: CREATE SCHEMA IF NOT EXISTS ("Dickson S. Guedes" <listas@guedesoft.net>) |
Ответы |
Re: CREATE SCHEMA IF NOT EXISTS
|
Список | 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 ---<<(())>>---
В списке pgsql-hackers по дате отправления: