Re: CREATE SCHEMA IF NOT EXISTS

Alvaro Herrera <alvherre@2ndquadrant.com>

From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: fabriziomello <fabriziomello@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>, David E. Wheeler <david@justatheory.com>, Dickson S. Guedes <listas@guedesoft.net>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-10-03T16:07:38Z
Lists: pgsql-hackers
Excerpts from Fabrízio de Royes Mello's message of mié oct 03 10:11:03 -0300 2012:

> Maybe something like this?
> 
>    ereport(ERROR,
>            (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
>             errmsg("IF NOT EXISTS cannot be used with schema elements"),
>             parser_errposition(@9)));

Seems reasonable, but where?  Please submit a complete patch.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


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