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