Postgres Pro
Downloads
Home   >   mailing lists

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

From Fabrízio de Royes Mello
Subject Re: CREATE SCHEMA IF NOT EXISTS
Date
Msg-id CAFcNs+qW7DeNV7+PcBD9HzZnm5TZsNhTVXhbRR9xurP-kFG6pA@mail.gmail.com
Whole thread Raw
In response to Re: CREATE SCHEMA IF NOT EXISTS  ("Dickson S. Guedes" <listas@guedesoft.net>)
Responses Re: CREATE SCHEMA IF NOT EXISTS
Re: CREATE SCHEMA IF NOT EXISTS
List pgsql-hackers
Tree view

2012/8/16 Dickson S. Guedes <listas@guedesoft.net>
2012/8/16 Fabrízio de Royes Mello <fabriziomello@gmail.com>:
> The attached patch implement this feature:
>
> CREATE SCHEMA [ IF NOT EXISTS ] schema_name [ AUTHORIZATION user_name ] [
> schema_element [ ... ] ]
> CREATE SCHEMA [ IF NOT EXISTS ] AUTHORIZATION user_name [ schema_element [
> ... ] ]
>
> Now, PostgreSQL don't trow an error if we use "IF NOT EXISTS" in "CREATE
> SCHEMA" statement.

I started testing this, but I didn't see regression tests for it.
Could you write them?.


The attached patch contains regression tests for it.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: external_pid_file not removed on postmaster exit
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: CREATE SCHEMA IF NOT EXISTS