pgsql: Allow CREATE TABLE IF EXIST so succeed if the schema is nonexist
Allow CREATE TABLE IF EXIST so succeed if the schema is nonexistent
Previously, CREATE TABLE IF EXIST threw an error if the schema was
nonexistent. This was done by passing 'missing_ok' to the function that
looks up the schema oid.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/7e2322dff30c04d90c0602d2b5ae24b4881db88b
Modified Files
--------------
src/backend/catalog/aclchk.c | 2 +-
src/backend/catalog/namespace.c | 86 +++++++++++++++++++++++------------
src/backend/commands/indexcmds.c | 2 +-
src/backend/commands/opclasscmds.c | 4 +-
src/backend/commands/trigger.c | 3 +-
src/backend/parser/parse_oper.c | 2 +-
src/backend/parser/parse_type.c | 2 +-
src/backend/utils/adt/xml.c | 6 +-
src/include/catalog/namespace.h | 2 +-
9 files changed, 68 insertions(+), 41 deletions(-)
--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
On Sat, Jan 26, 2013 at 1:24 PM, Bruce Momjian <bruce@momjian.us> wrote:
Allow CREATE TABLE IF EXIST so succeed if the schema is nonexistent
you meant DROP TABLE IF EXISTS, right?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
On Sat, Jan 26, 2013 at 01:30:53PM -0500, Jaime Casanova wrote:
On Sat, Jan 26, 2013 at 1:24 PM, Bruce Momjian <bruce@momjian.us> wrote:
Allow CREATE TABLE IF EXIST so succeed if the schema is nonexistent
you meant DROP TABLE IF EXISTS, right?
Oh, yes. DROP TABLE. I needed to update some C comments anyway so I
added the correct in that commit message. Thanks for the heads-up.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers