2012/10/3 Alvaro Herrera <[email protected]> > 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. > > The attached patch implements the behavior we've discussed.
If we use "IF NOT EXISTS" with schema elements then occurs an error like
this:
[local]:5432 fabrizio@fabrizio=# CREATE SCHEMA IF NOT EXISTS test_schema_1
CREATE TABLE abc (
a serial,
b int UNIQUE
);
ERROR: IF NOT EXISTS cannot be used with schema elements
LINE 1: CREATE SCHEMA IF NOT EXISTS test_schema_1
^
Time: 0,773 ms
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
create_schema_if_not_exists_v7.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
