Horton
Menu

Re: CREATE SCHEMA IF NOT EXISTS

David E. Wheeler <david@justatheory.com>

View thread
From: "David E. Wheeler" <david@justatheory.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Dickson S. Guedes <listas@guedesoft.net>, fabriziomello <fabriziomello@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-10-02T19:16:37Z
Lists: pgsql-hackers 
On Oct 2, 2012, at 12:08 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

> create schema if not exists foo create table first (a int);
> create schema if not exists foo create table second (a int);
> 
> 
> As far as I can see, with the patch as it currently stands, you would
> end up with only table "first" in the schema, which seems very
> surprising to me.

Yeah, I think the second should die. CINE should only work if there are no other objects created as part of the statement, IMHO.

Best,

David

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