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: Pgsql Hackers <pgsql-hackers@postgresql.org>, david@justatheory.com
Date: 2012-08-28T15:19:40Z
Lists: pgsql-hackers 
2012/8/27 Dickson S. Guedes <listas@guedesoft.net>

>
> [...]
>
> Two questions:
>
> - Should this patch implements others INEs like ADD COLUMN IF NOT EXISTS?
>

If this feature is important I believe we must implement it.

Exists several "CREATE" statements without "IF NOT EXISTS" option too, so
we can discuss more about it and I can implement it in this patch or in
another.



> - Should pg_dump or pg_restore support some kind of flag to use a
>   CREATE SCHEMA IF NOT EXISTS ... instead CREATE SCHEMA ...?
>
>
I can't imagine a use case for this feature... can you explain more about
your idea?

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