Horton
Menu

Re: CREATE SCHEMA IF NOT EXISTS

Dickson S. Guedes <listas@guedesoft.net>

View thread
From: "Dickson S. Guedes" <listas@guedesoft.net>
To: fabriziomello@gmail.com
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-08-17T00:44:22Z
Lists: pgsql-hackers 
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?.

Best.
-- 
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

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