Horton
Menu

Re: CREATE SCHEMA IF NOT EXISTS

Fabrízio de Royes Mello <fabriziomello@gmail.com>

View thread
From: Fabrízio de Royes Mello <fabriziomello@gmail.com>
To: "Dickson S. Guedes" <listas@guedesoft.net>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-08-17T13:16:30Z
Lists: pgsql-hackers

Attachments

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
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Document the lack of reading the PGDATABASE environment variable in