Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit73f6305

Browse files
author
Neil Conway
committed
Add support for temporary views, including documentation and regression
tests. Contributed by Koju Iijima, review from Neil Conway, Gavin Sherryand Tom Lane.Also, fix error in description of WITH CHECK OPTION clause in the CREATEVIEW reference page: it should be "CASCADED", not "CASCADE".
1 parentf94197e commit73f6305

File tree

7 files changed

+508
-30
lines changed

7 files changed

+508
-30
lines changed

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.91 2005/01/22 23:22:17 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.92 2005/02/02 06:35:59 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -66,12 +66,12 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is:
6666

6767
<para>
6868
If a schema name is given (for example, <literal>CREATE TABLE
69-
myschema.mytable ...</>) then the table is created in the
70-
specifiedschema. Otherwise it is created in the current schema.
71-
Temporarytables exist in a special schema, so a schema name may not be
72-
givenwhen creating a temporary table.
73-
The table name must bedistinct from the name of any other table,
74-
sequence, index, or viewin the same schema.
69+
myschema.mytable ...</>) then the table is created in the specified
70+
schema. Otherwise it is created in the current schema. Temporary
71+
tables exist in a special schema, so a schema name may not be given
72+
when creating a temporary table. The name of the table must be
73+
distinct from the name of any other table, sequence, index, or view
74+
in the same schema.
7575
</para>
7676

7777
<para>

‎doc/src/sgml/ref/create_view.sgml

Lines changed: 36 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_view.sgml,v 1.29 2005/01/04 00:39:53 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_view.sgml,v 1.30 2005/02/02 06:35:59 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,7 @@ PostgreSQL documentation
2020

2121
<refsynopsisdiv>
2222
<synopsis>
23-
CREATE [ OR REPLACE ] VIEW <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable
23+
CREATE [ OR REPLACE ][ TEMP | TEMPORARY ]VIEW <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable
2424
class="PARAMETER">column_name</replaceable> [, ...] ) ] AS <replaceable class="PARAMETER">query</replaceable>
2525
</synopsis>
2626
</refsynopsisdiv>
@@ -43,17 +43,41 @@ class="PARAMETER">column_name</replaceable> [, ...] ) ] AS <replaceable class="P
4343

4444
<para>
4545
If a schema name is given (for example, <literal>CREATE VIEW
46-
myschema.myview ...</>) then the view is created in the
47-
specified schema. Otherwise it is created in the current schema.
48-
The view name must be distinct from the name of any other view, table,
49-
sequence, or index in the same schema.
46+
myschema.myview ...</>) then the view is created in the specified
47+
schema. Otherwise it is created in the current schema. Temporary
48+
views exist in a special schema, so a schema name may not be given
49+
when creating a temporary view. The name of the view must be
50+
distinct from the name of any other view, table, sequence, or index
51+
in the same schema.
5052
</para>
5153
</refsect1>
5254

5355
<refsect1>
5456
<title>Parameters</title>
5557

5658
<variablelist>
59+
<varlistentry>
60+
<term><literal>TEMPORARY</> or <literal>TEMP</></term>
61+
<listitem>
62+
<para>
63+
If specified, the view is created as a temporary view.
64+
Temporary views are automatically dropped at the end of the
65+
current session. Temporary views are automatically placed in the
66+
current backend's local temporary schema, so it is illegal to
67+
specify a schema-qualified name for a temporary view. Existing
68+
permanent relations with the same name are not visible to the
69+
current session while the temporary view exists, unless they are
70+
referenced with schema-qualified names.
71+
</para>
72+
73+
<para>
74+
If any of the base tables referenced by the view are temporary,
75+
the view is created as a temporary view (whether
76+
<literal>TEMPORARY</literal> is specified or not).
77+
</para>
78+
</listitem>
79+
</varlistentry>
80+
5781
<varlistentry>
5882
<term><replaceable class="parameter">name</replaceable></term>
5983
<listitem>
@@ -102,7 +126,8 @@ class="PARAMETER">column_name</replaceable> [, ...] ) ] AS <replaceable class="P
102126
</para>
103127

104128
<para>
105-
Use the <command>DROP VIEW</command> statement to drop views.
129+
Use the <xref linkend="sql-dropview" endterm="sql-dropview-title">
130+
statement to drop views.
106131
</para>
107132

108133
<para>
@@ -153,7 +178,7 @@ CREATE VIEW comedies AS
153178
<synopsis>
154179
CREATE VIEW <replaceable class="parameter">name</replaceable> [ ( <replaceable class="parameter">column</replaceable> [, ...] ) ]
155180
AS query
156-
[ WITH [CASCADE | LOCAL ] CHECK OPTION ]
181+
[ WITH [CASCADED | LOCAL ] CHECK OPTION ]
157182
</synopsis>
158183
</para>
159184

@@ -184,12 +209,12 @@ CREATE VIEW <replaceable class="parameter">name</replaceable> [ ( <replaceable c
184209
</varlistentry>
185210

186211
<varlistentry>
187-
<term><literal>CASCADE</literal></term>
212+
<term><literal>CASCADED</literal></term>
188213
<listitem>
189214
<para>
190215
Check for integrity on this view and on any dependent
191-
view. <literal>CASCADE</> is assumed if neither
192-
<literal>CASCADE</> nor <literal>LOCAL</> is specified.
216+
view. <literal>CASCADED</> is assumed if neither
217+
<literal>CASCADED</> nor <literal>LOCAL</> is specified.
193218
</para>
194219
</listitem>
195220
</varlistentry>

‎src/backend/commands/view.c

Lines changed: 71 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $PostgreSQL: pgsql/src/backend/commands/view.c,v 1.86 2004/12/31 21:59:42 pgsql Exp $
11+
* $PostgreSQL: pgsql/src/backend/commands/view.c,v 1.87 2005/02/02 06:36:00 neilc Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -21,6 +21,7 @@
2121
#include"commands/view.h"
2222
#include"miscadmin.h"
2323
#include"nodes/makefuncs.h"
24+
#include"optimizer/clauses.h"
2425
#include"parser/parse_relation.h"
2526
#include"rewrite/rewriteDefine.h"
2627
#include"rewrite/rewriteManip.h"
@@ -30,7 +31,55 @@
3031

3132

3233
staticvoidcheckViewTupleDesc(TupleDescnewdesc,TupleDescolddesc);
34+
staticboolisViewOnTempTable_walker(Node*node,void*context);
3335

36+
/*---------------------------------------------------------------------
37+
* isViewOnTempTable
38+
*
39+
* Returns true iff any of the relations underlying this view are
40+
* temporary tables.
41+
*---------------------------------------------------------------------
42+
*/
43+
staticbool
44+
isViewOnTempTable(Query*viewParse)
45+
{
46+
returnisViewOnTempTable_walker((Node*)viewParse,NULL);
47+
}
48+
49+
staticbool
50+
isViewOnTempTable_walker(Node*node,void*context)
51+
{
52+
if (node==NULL)
53+
return false;
54+
55+
if (IsA(node,Query))
56+
{
57+
Query*query= (Query*)node;
58+
ListCell*rtable;
59+
60+
foreach (rtable,query->rtable)
61+
{
62+
RangeTblEntry*rte=lfirst(rtable);
63+
if (rte->rtekind==RTE_RELATION)
64+
{
65+
Relationrel=heap_open(rte->relid,AccessShareLock);
66+
boolistemp=rel->rd_istemp;
67+
heap_close(rel,AccessShareLock);
68+
if (istemp)
69+
return true;
70+
}
71+
}
72+
73+
returnquery_tree_walker(query,
74+
isViewOnTempTable_walker,
75+
context,
76+
QTW_IGNORE_JOINALIASES);
77+
}
78+
79+
returnexpression_tree_walker(node,
80+
isViewOnTempTable_walker,
81+
context);
82+
}
3483

3584
/*---------------------------------------------------------------------
3685
* DefineVirtualRelation
@@ -117,6 +166,13 @@ DefineVirtualRelation(const RangeVar *relation, List *tlist, bool replace)
117166
aclcheck_error(ACLCHECK_NOT_OWNER,ACL_KIND_CLASS,
118167
RelationGetRelationName(rel));
119168

169+
/*
170+
* Due to the namespace visibility rules for temporary
171+
* objects, we should only end up replacing a temporary view
172+
* with another temporary view, and vice versa.
173+
*/
174+
Assert(relation->istemp==rel->rd_istemp);
175+
120176
/*
121177
* Create a tuple descriptor to compare against the existing view,
122178
* and verify it matches.
@@ -326,17 +382,29 @@ UpdateRangeTableOfViewParse(Oid viewOid, Query *viewParse)
326382
*-------------------------------------------------------------------
327383
*/
328384
void
329-
DefineView(constRangeVar*view,Query*viewParse,boolreplace)
385+
DefineView(RangeVar*view,Query*viewParse,boolreplace)
330386
{
331387
OidviewOid;
332388

389+
/*
390+
* If the user didn't explicitly ask for a temporary view, check
391+
* whether we need one implicitly.
392+
*/
393+
if (!view->istemp)
394+
{
395+
view->istemp=isViewOnTempTable(viewParse);
396+
if (view->istemp)
397+
ereport(NOTICE,
398+
(errmsg("view \"%s\" will be a temporary view",
399+
view->relname)));
400+
}
401+
333402
/*
334403
* Create the view relation
335404
*
336405
* NOTE: if it already exists and replace is false, the xact will be
337406
* aborted.
338407
*/
339-
340408
viewOid=DefineVirtualRelation(view,viewParse->targetList,replace);
341409

342410
/*

‎src/backend/parser/gram.y

Lines changed: 18 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@
1111
*
1212
*
1313
* IDENTIFICATION
14-
* $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.482 2005/01/27 03:17:59 tgl Exp $
14+
* $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.483 2005/02/02 06:36:01 neilc Exp $
1515
*
1616
* HISTORY
1717
* AUTHORDATEMAJOR EVENT
@@ -4075,24 +4075,35 @@ transaction_mode_list_or_empty:
40754075

40764076
/*****************************************************************************
40774077
*
4078-
*QUERY:
4079-
*create view <viewname> '('target-list ')' AS <query>
4078+
*QUERY:
4079+
*CREATE [ OR REPLACE ] [ TEMP ] VIEW <viewname> '('target-list ')' AS <query>
40804080
*
40814081
*****************************************************************************/
40824082

4083-
ViewStmt:CREATEopt_or_replace VIEW qualified_name opt_column_list
4083+
ViewStmt:CREATEOptTemp VIEW qualified_name opt_column_list
40844084
AS SelectStmt
40854085
{
40864086
ViewStmt *n = makeNode(ViewStmt);
4087-
n->replace =$2;
4087+
n->replace =false;
40884088
n->view =$4;
4089+
n->view->istemp =$2;
40894090
n->aliases =$5;
40904091
n->query = (Query *)$7;
4091-
$$ = (Node *)n;
4092+
$$ = (Node *) n;
4093+
}
4094+
| CREATE OR REPLACE OptTemp VIEW qualified_name opt_column_list
4095+
AS SelectStmt
4096+
{
4097+
ViewStmt *n = makeNode(ViewStmt);
4098+
n->replace =true;
4099+
n->view =$6;
4100+
n->view->istemp =$4;
4101+
n->aliases =$7;
4102+
n->query = (Query *)$9;
4103+
$$ = (Node *) n;
40924104
}
40934105
;
40944106

4095-
40964107
/*****************************************************************************
40974108
*
40984109
*QUERY:

‎src/include/commands/view.h

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $PostgreSQL: pgsql/src/include/commands/view.h,v 1.21 2004/12/31 22:03:28 pgsql Exp $
10+
* $PostgreSQL: pgsql/src/include/commands/view.h,v 1.22 2005/02/02 06:36:01 neilc Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -16,7 +16,7 @@
1616

1717
#include"nodes/parsenodes.h"
1818

19-
externvoidDefineView(constRangeVar*view,Query*view_parse,boolreplace);
19+
externvoidDefineView(RangeVar*view,Query*view_parse,boolreplace);
2020
externvoidRemoveView(constRangeVar*view,DropBehaviorbehavior);
2121

2222
#endif/* VIEW_H */

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp