From 98e8b4805324d8ba0b196b8ffaafd5ddd3051ea1 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 5 Nov 2004 19:17:13 +0000 Subject: Create 'default_tablespace' GUC variable that supplies a TABLESPACE clause implicitly whenever one is not given explicitly. Remove concept of a schema having an associated tablespace, and simplify the rules for selecting a default tablespace for a table or index. It's now just (a) explicit TABLESPACE clause; (b) default_tablespace if that's not an empty string; (c) database's default. This will allow pg_dump to use SET commands instead of tablespace clauses to determine object locations (but I didn't actually make it do so). All per recent discussions. --- src/interfaces/ecpg/preproc/preproc.y | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/interfaces') diff --git a/src/interfaces/ecpg/preproc/preproc.y b/src/interfaces/ecpg/preproc/preproc.y index 0ded0cb6041..fa579afd6a2 100644 --- a/src/interfaces/ecpg/preproc/preproc.y +++ b/src/interfaces/ecpg/preproc/preproc.y @@ -1,4 +1,4 @@ -/* $PostgreSQL: pgsql/src/interfaces/ecpg/preproc/preproc.y,v 1.299 2004/11/01 13:17:12 davec Exp $ */ +/* $PostgreSQL: pgsql/src/interfaces/ecpg/preproc/preproc.y,v 1.300 2004/11/05 19:16:43 tgl Exp $ */ /* Copyright comment */ %{ @@ -1013,10 +1013,10 @@ DropGroupStmt: DROP GROUP_P UserId * *****************************************************************************/ -CreateSchemaStmt: CREATE SCHEMA OptSchemaName AUTHORIZATION UserId OptTableSpace OptSchemaEltList - { $$ = cat_str(6, make_str("create schema"), $3, make_str("authorization"), $5, $6, $7); } - | CREATE SCHEMA ColId OptTableSpace OptSchemaEltList - { $$ = cat_str(4, make_str("create schema"), $3, $4, $5); } +CreateSchemaStmt: CREATE SCHEMA OptSchemaName AUTHORIZATION UserId OptSchemaEltList + { $$ = cat_str(5, make_str("create schema"), $3, make_str("authorization"), $5, $6); } + | CREATE SCHEMA ColId OptSchemaEltList + { $$ = cat_str(3, make_str("create schema"), $3, $4); } ; OptSchemaName: ColId { $$ = $1; } -- cgit v1.2.3