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

Commitea7d519

Browse files
committed
Add a new column proiswindow to pg_proc. It doesn't actually do anything
useful yet, but I'm tired of re-merging this aspect of the window functionspatch.
1 parentcae565e commitea7d519

File tree

8 files changed

+2169
-2143
lines changed

8 files changed

+2169
-2143
lines changed

‎doc/src/sgml/catalogs.sgml‎

Lines changed: 8 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.185 2008/12/1916:25:16 petere Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.186 2008/12/1918:25:19 tgl Exp $ -->
22
<!--
33
Documentation of the system catalogs, directed toward PostgreSQL developers
44
-->
@@ -3840,6 +3840,13 @@
38403840
<entry>Function is an aggregate function</entry>
38413841
</row>
38423842

3843+
<row>
3844+
<entry><structfield>proiswindow</structfield></entry>
3845+
<entry><type>bool</type></entry>
3846+
<entry></entry>
3847+
<entry>Function is a window function</entry>
3848+
</row>
3849+
38433850
<row>
38443851
<entry><structfield>prosecdef</structfield></entry>
38453852
<entry><type>bool</type></entry>

‎src/backend/catalog/pg_proc.c‎

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $PostgreSQL: pgsql/src/backend/catalog/pg_proc.c,v 1.156 2008/12/18 18:20:33 tgl Exp $
11+
* $PostgreSQL: pgsql/src/backend/catalog/pg_proc.c,v 1.157 2008/12/19 18:25:19 tgl Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -292,6 +292,8 @@ ProcedureCreate(const char *procedureName,
292292
values[Anum_pg_proc_prorows-1]=Float4GetDatum(prorows);
293293
values[Anum_pg_proc_provariadic-1]=ObjectIdGetDatum(variadicType);
294294
values[Anum_pg_proc_proisagg-1]=BoolGetDatum(isAgg);
295+
/* XXX we don't currently have a way to make new window functions */
296+
values[Anum_pg_proc_proiswindow-1]=BoolGetDatum(false);
295297
values[Anum_pg_proc_prosecdef-1]=BoolGetDatum(security_definer);
296298
values[Anum_pg_proc_proisstrict-1]=BoolGetDatum(isStrict);
297299
values[Anum_pg_proc_proretset-1]=BoolGetDatum(returnsSet);

‎src/include/catalog/catversion.h‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@
3737
* Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group
3838
* Portions Copyright (c) 1994, Regents of the University of California
3939
*
40-
* $PostgreSQL: pgsql/src/include/catalog/catversion.h,v 1.512 2008/12/1916:25:18 petere Exp $
40+
* $PostgreSQL: pgsql/src/include/catalog/catversion.h,v 1.513 2008/12/1918:25:19 tgl Exp $
4141
*
4242
*-------------------------------------------------------------------------
4343
*/
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO200812191
56+
#defineCATALOG_VERSION_NO200812192
5757

5858
#endif

‎src/include/catalog/pg_attribute.h‎

Lines changed: 35 additions & 33 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
* Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group
99
* Portions Copyright (c) 1994, Regents of the University of California
1010
*
11-
* $PostgreSQL: pgsql/src/include/catalog/pg_attribute.h,v 1.143 2008/12/18 18:20:34 tgl Exp $
11+
* $PostgreSQL: pgsql/src/include/catalog/pg_attribute.h,v 1.144 2008/12/19 18:25:19 tgl Exp $
1212
*
1313
* NOTES
1414
* the genbki.sh script reads this file and generates .bki
@@ -295,22 +295,23 @@ DATA(insert ( 1247 tableoid26 0 4 -7 0 -1 -1 t p i t f f t 0));
295295
{ 1255, {"prorows"}, 700, -1, 4,6, 0, -1, -1, FLOAT4PASSBYVAL, 'p', 'i', true, false, false, true, 0 }, \
296296
{ 1255, {"provariadic"},26, -1, 4,7, 0, -1, -1, true, 'p', 'i', true, false, false, true, 0 }, \
297297
{ 1255, {"proisagg"},16, -1, 1,8, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
298-
{ 1255, {"prosecdef"},16, -1, 1,9, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
299-
{ 1255, {"proisstrict"},16, -1, 1, 10, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
300-
{ 1255, {"proretset"},16, -1, 1, 11, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
301-
{ 1255, {"provolatile"},18, -1, 1, 12, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
302-
{ 1255, {"pronargs"},21, -1, 2, 13, 0, -1, -1, true, 'p', 's', true, false, false, true, 0 }, \
303-
{ 1255, {"pronargdefaults"},21, -1, 2, 14, 0, -1, -1, true, 'p', 's', true, false, false, true, 0 }, \
304-
{ 1255, {"prorettype"},26, -1, 4, 15, 0, -1, -1, true, 'p', 'i', true, false, false, true, 0 }, \
305-
{ 1255, {"proargtypes"},30, -1, -1, 16, 1, -1, -1, false, 'p', 'i', true, false, false, true, 0 }, \
306-
{ 1255, {"proallargtypes"}, 1028, -1, -1, 17, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
307-
{ 1255, {"proargmodes"}, 1002, -1, -1, 18, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
308-
{ 1255, {"proargnames"}, 1009, -1, -1, 19, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
309-
{ 1255, {"proargdefaults"},25, -1, -1, 20, 0, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
310-
{ 1255, {"prosrc"},25, -1, -1, 21, 0, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
311-
{ 1255, {"probin"},17, -1, -1, 22, 0, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
312-
{ 1255, {"proconfig"}, 1009, -1, -1, 23, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
313-
{ 1255, {"proacl"}, 1034, -1, -1, 24, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }
298+
{ 1255, {"proiswindow"},16, -1, 1,9, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
299+
{ 1255, {"prosecdef"},16, -1, 1, 10, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
300+
{ 1255, {"proisstrict"},16, -1, 1, 11, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
301+
{ 1255, {"proretset"},16, -1, 1, 12, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
302+
{ 1255, {"provolatile"},18, -1, 1, 13, 0, -1, -1, true, 'p', 'c', true, false, false, true, 0 }, \
303+
{ 1255, {"pronargs"},21, -1, 2, 14, 0, -1, -1, true, 'p', 's', true, false, false, true, 0 }, \
304+
{ 1255, {"pronargdefaults"},21, -1, 2, 15, 0, -1, -1, true, 'p', 's', true, false, false, true, 0 }, \
305+
{ 1255, {"prorettype"},26, -1, 4, 16, 0, -1, -1, true, 'p', 'i', true, false, false, true, 0 }, \
306+
{ 1255, {"proargtypes"},30, -1, -1, 17, 1, -1, -1, false, 'p', 'i', true, false, false, true, 0 }, \
307+
{ 1255, {"proallargtypes"}, 1028, -1, -1, 18, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
308+
{ 1255, {"proargmodes"}, 1002, -1, -1, 19, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
309+
{ 1255, {"proargnames"}, 1009, -1, -1, 20, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
310+
{ 1255, {"proargdefaults"},25, -1, -1, 21, 0, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
311+
{ 1255, {"prosrc"},25, -1, -1, 22, 0, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
312+
{ 1255, {"probin"},17, -1, -1, 23, 0, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
313+
{ 1255, {"proconfig"}, 1009, -1, -1, 24, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }, \
314+
{ 1255, {"proacl"}, 1034, -1, -1, 25, 1, -1, -1, false, 'x', 'i', false, false, false, true, 0 }
314315

315316
DATA(insert (1255proname19-1NAMEDATALEN10-1-1fpctfft0));
316317
DATA(insert (1255pronamespace26-1420-1-1tpitfft0));
@@ -320,22 +321,23 @@ DATA(insert ( 1255 procost 700 -1 4 5 0 -1 -1 FLOAT4PASSBYVAL p i t f f t
320321
DATA(insert (1255prorows700-1460-1-1FLOAT4PASSBYVALpitfft0));
321322
DATA(insert (1255provariadic26-1470-1-1tpitfft0));
322323
DATA(insert (1255proisagg16-1180-1-1tpctfft0));
323-
DATA(insert (1255prosecdef16-1190-1-1tpctfft0));
324-
DATA(insert (1255proisstrict16-11100-1-1tpctfft0));
325-
DATA(insert (1255proretset16-11110-1-1tpctfft0));
326-
DATA(insert (1255provolatile18-11120-1-1tpctfft0));
327-
DATA(insert (1255pronargs21-12130-1-1tpstfft0));
328-
DATA(insert (1255pronargdefaults21-12140-1-1tpstfft0));
329-
DATA(insert (1255prorettype26-14150-1-1tpitfft0));
330-
DATA(insert (1255proargtypes30-1-1161-1-1fpitfft0));
331-
DATA(insert (1255proallargtypes1028-1-1171-1-1fxiffft0));
332-
DATA(insert (1255proargmodes1002-1-1181-1-1fxiffft0));
333-
DATA(insert (1255proargnames1009-1-1191-1-1fxiffft0));
334-
DATA(insert (1255proargdefaults25-1-1200-1-1fxiffft0));
335-
DATA(insert (1255prosrc25-1-1210-1-1fxiffft0));
336-
DATA(insert (1255probin17-1-1220-1-1fxiffft0));
337-
DATA(insert (1255proconfig1009-1-1231-1-1fxiffft0));
338-
DATA(insert (1255proacl1034-1-1241-1-1fxiffft0));
324+
DATA(insert (1255proiswindow16-1190-1-1tpctfft0));
325+
DATA(insert (1255prosecdef16-11100-1-1tpctfft0));
326+
DATA(insert (1255proisstrict16-11110-1-1tpctfft0));
327+
DATA(insert (1255proretset16-11120-1-1tpctfft0));
328+
DATA(insert (1255provolatile18-11130-1-1tpctfft0));
329+
DATA(insert (1255pronargs21-12140-1-1tpstfft0));
330+
DATA(insert (1255pronargdefaults21-12150-1-1tpstfft0));
331+
DATA(insert (1255prorettype26-14160-1-1tpitfft0));
332+
DATA(insert (1255proargtypes30-1-1171-1-1fpitfft0));
333+
DATA(insert (1255proallargtypes1028-1-1181-1-1fxiffft0));
334+
DATA(insert (1255proargmodes1002-1-1191-1-1fxiffft0));
335+
DATA(insert (1255proargnames1009-1-1201-1-1fxiffft0));
336+
DATA(insert (1255proargdefaults25-1-1210-1-1fxiffft0));
337+
DATA(insert (1255prosrc25-1-1220-1-1fxiffft0));
338+
DATA(insert (1255probin17-1-1230-1-1fxiffft0));
339+
DATA(insert (1255proconfig1009-1-1241-1-1fxiffft0));
340+
DATA(insert (1255proacl1034-1-1251-1-1fxiffft0));
339341
DATA(insert (1255ctid2706-10-1-1fpstfft0));
340342
DATA(insert (1255oid2604-20-1-1tpitfft0));
341343
DATA(insert (1255xmin2804-30-1-1tpitfft0));

‎src/include/catalog/pg_class.h‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
* Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group
99
* Portions Copyright (c) 1994, Regents of the University of California
1010
*
11-
* $PostgreSQL: pgsql/src/include/catalog/pg_class.h,v 1.109 2008/12/04 17:51:27 petere Exp $
11+
* $PostgreSQL: pgsql/src/include/catalog/pg_class.h,v 1.110 2008/12/19 18:25:19 tgl Exp $
1212
*
1313
* NOTES
1414
* the genbki.sh script reads this file and generates .bki
@@ -125,7 +125,7 @@ DATA(insert OID = 1247 ( pg_typePGNSP 71 PGUID 0 1247 0 0 0 0 0 f f r 28 0 t
125125
DESCR("");
126126
DATA(insertOID=1249 (pg_attributePGNSP75PGUID0124900000ffr170fffff3_null__null_ ));
127127
DESCR("");
128-
DATA(insertOID=1255 (pg_procPGNSP81PGUID0125500000ffr240tffff3_null__null_ ));
128+
DATA(insertOID=1255 (pg_procPGNSP81PGUID0125500000ffr250tffff3_null__null_ ));
129129
DESCR("");
130130
DATA(insertOID=1259 (pg_classPGNSP83PGUID0125900000ffr240tffff3_null__null_ ));
131131
DESCR("");

0 commit comments

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