diff options
| author | Tom Lane | 2002-07-18 16:47:26 +0000 |
|---|---|---|
| committer | Tom Lane | 2002-07-18 16:47:26 +0000 |
| commit | 11333426f103bedef311d1dd88b62176276b8544 (patch) | |
| tree | b5f5e131cec41db79d3586aa2d4528d7f3067b8a /src/bin/initdb | |
| parent | 8bed350c4ae6a5b4e7c1bd73b67ca4014960876b (diff) | |
Implement DROP SCHEMA. It lacks support for dropping conversions and
operator classes, both of which are schema-local and so should really
be droppable.
Diffstat (limited to 'src/bin/initdb')
| -rw-r--r-- | src/bin/initdb/initdb.sh | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh index a88eed353b1..9902a24fc4f 100644 --- a/src/bin/initdb/initdb.sh +++ b/src/bin/initdb/initdb.sh @@ -27,7 +27,7 @@ # Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # -# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.159 2002/07/18 02:02:30 ishii Exp $ +# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.160 2002/07/18 16:47:25 tgl Exp $ # #------------------------------------------------------------------------- @@ -717,6 +717,9 @@ INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_language; INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_operator; INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_rewrite; INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_trigger; +-- restriction here to avoid pinning the public namespace +INSERT INTO pg_depend SELECT 0,0,0, tableoid,oid,0, 'p' FROM pg_namespace \ + WHERE nspname LIKE 'pg%'; EOF if [ "$?" -ne 0 ]; then exit_nicely |