Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
Дата
Msg-id CAFcNs+o3SB8YfGU9S_5vkQB+3eVVPvDVSn-=h5H7ptqQc7ku9w@mail.gmail.com
обсуждение исходный текст
Ответ на Patch to add support of "IF NOT EXISTS" to others "CREATE" statements  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Ответы Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements  (Peter Eisentraut <peter_e@gmx.net>)
Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements  (Andres Freund <andres@2ndquadrant.com>)
Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
Список pgsql-hackers
Дерево обсуждения

On Fri, May 24, 2013 at 12:22 PM, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote:
Hi all,

I working in a patch to include support of "IF NOT EXISTS" into "CREATE" statements that not have it yet.

I started with "DefineStmt" section from "src/backend/parser/gram.y":
- CREATE AGGREGATE [ IF NOT EXISTS ] ...
- CREATE OPERATOR [ IF NOT EXISTS ] ...
- CREATE TYPE [ IF NOT EXISTS ] ... [AS [{ENUM | RANGE}] (...)]
- CREATE TEXT SEARCH {PARSER | DITIONARY | TEMPLATE | CONFIGURATION} [ IF NOT EXISTS ] ...
- CREATE COLLATION [ IF NOT EXISTS ] ...

 
The attached patch add support to "IF NOT EXISTS" to "CREATE" statements listed below:

- CREATE AGGREGATE [ IF NOT EXISTS ] ...
- CREATE CAST [ IF NOT EXISTS ] ...
- CREATE COLLATION [ IF NOT EXISTS ] ...
- CREATE OPERATOR [ IF NOT EXISTS ] ...
- CREATE TEXT SEARCH {PARSER | DICTIONARY | TEMPLATE | CONFIGURATION} [ IF NOT EXISTS ] ...
- CREATE TYPE [ IF NOT EXISTS ] ... [AS [{ENUM | RANGE}] (...)]

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [9.3] Automatically updatable views vs writable foreign tables