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+rQT5gLg6z=j3yStquPUh7GdtpVQUGrJoEmig4Ez+FDFQ@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
List 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

pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.3] writable foreign tables
Next
From: David Fetter
Date:
Subject: Re: [v9.3] writable foreign tables