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

Commitd6dfa1e

Browse files
committed
Update oidjoins test to match CVS HEAD.
1 parent556dfb5 commitd6dfa1e

File tree

3 files changed

+52
-7
lines changed

3 files changed

+52
-7
lines changed

‎src/test/regress/expected/oidjoins.out

Lines changed: 17 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
2+
-- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
33
--
44
SELECTctid, aggfnoid
55
FROMpg_catalog.pg_aggregate fk
@@ -41,6 +41,14 @@ WHEREaggtranstype != 0 AND
4141
------+--------------
4242
(0 rows)
4343

44+
SELECTctid, amkeytype
45+
FROMpg_catalog.pg_am fk
46+
WHEREamkeytype != 0 AND
47+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amkeytype);
48+
ctid | amkeytype
49+
------+-----------
50+
(0 rows)
51+
4452
SELECTctid, aminsert
4553
FROMpg_catalog.pg_am fk
4654
WHEREaminsert != 0 AND
@@ -921,6 +929,14 @@ WHEREtypmodout != 0 AND
921929
------+-----------
922930
(0 rows)
923931

932+
SELECTctid, typanalyze
933+
FROMpg_catalog.pg_type fk
934+
WHEREtypanalyze != 0 AND
935+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
936+
ctid | typanalyze
937+
------+------------
938+
(0 rows)
939+
924940
SELECTctid, typbasetype
925941
FROMpg_catalog.pg_type fk
926942
WHEREtypbasetype != 0 AND

‎src/test/regress/sql/oidjoins.sql

Lines changed: 9 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
2+
-- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
33
--
44
SELECTctid, aggfnoid
55
FROMpg_catalog.pg_aggregate fk
@@ -21,6 +21,10 @@ SELECTctid, aggtranstype
2121
FROMpg_catalog.pg_aggregate fk
2222
WHEREaggtranstype!=0AND
2323
NOT EXISTS(SELECT1FROMpg_catalog.pg_type pkWHEREpk.oid=fk.aggtranstype);
24+
SELECTctid, amkeytype
25+
FROMpg_catalog.pg_am fk
26+
WHEREamkeytype!=0AND
27+
NOT EXISTS(SELECT1FROMpg_catalog.pg_type pkWHEREpk.oid=fk.amkeytype);
2428
SELECTctid, aminsert
2529
FROMpg_catalog.pg_am fk
2630
WHEREaminsert!=0AND
@@ -461,6 +465,10 @@ SELECTctid, typmodout
461465
FROMpg_catalog.pg_type fk
462466
WHEREtypmodout!=0AND
463467
NOT EXISTS(SELECT1FROMpg_catalog.pg_proc pkWHEREpk.oid=fk.typmodout);
468+
SELECTctid, typanalyze
469+
FROMpg_catalog.pg_type fk
470+
WHEREtypanalyze!=0AND
471+
NOT EXISTS(SELECT1FROMpg_catalog.pg_proc pkWHEREpk.oid=fk.typanalyze);
464472
SELECTctid, typbasetype
465473
FROMpg_catalog.pg_type fk
466474
WHEREtypbasetype!=0AND

‎src/tools/findoidjoins/README

Lines changed: 26 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
$PostgreSQL: pgsql/src/tools/findoidjoins/README,v 1.5 2008/03/21 13:23:29 momjian Exp $
1+
$PostgreSQL: pgsql/src/tools/findoidjoins/README,v 1.6 2008/10/13 12:59:57 tgl Exp $
22

33
findoidjoins
44
============
@@ -9,10 +9,10 @@ anything but an empty database, such as template1; else it's likely to
99
be very slow.
1010

1111
Run on an empty database, it returns the system join relationships (shown
12-
below for 8.3). Note that unexpected matches may indicate bogus entries
12+
below for 8.4devel). Note that unexpected matches may indicate bogus entries
1313
in system tables --- don't accept a peculiar match without question.
1414
In particular, a field shown as joining to more than one target table is
15-
probably messed up. In 8.3, the *only* fields that should join to more
15+
probably messed up. In 8.4devel, the *only* fields that should join to more
1616
than one target are pg_description.objoid, pg_depend.objid,
1717
pg_depend.refobjid, pg_shdescription.objoid, pg_shdepend.objid, and
1818
pg_shdepend.refobjid. (Running make_oidjoins_check is an easy way to spot
@@ -31,10 +31,12 @@ revision in the patterns of cross-links between system tables.
3131
(Ideally we'd just regenerate the script as part of the regression
3232
tests themselves, but that seems too slow...)
3333

34-
NOTE: in 8.3, make_oidjoins_check produces two bogus join checks:
34+
NOTE: in 8.4devel, make_oidjoins_check produces two bogus join checks:
3535
Join pg_catalog.pg_class.relfilenode => pg_catalog.pg_class.oid
3636
Join pg_catalog.pg_database.datlastsysoid => pg_catalog.pg_database.oid
3737
These are artifacts and should not be added to the oidjoins regress test.
38+
You might also get output for pg_shdepend.refobjid and pg_shdescription.objoid,
39+
neither of which should be added.
3840

3941
---------------------------------------------------------------------------
4042

@@ -43,10 +45,11 @@ Join pg_catalog.pg_aggregate.aggtransfn => pg_catalog.pg_proc.oid
4345
Join pg_catalog.pg_aggregate.aggfinalfn => pg_catalog.pg_proc.oid
4446
Join pg_catalog.pg_aggregate.aggsortop => pg_catalog.pg_operator.oid
4547
Join pg_catalog.pg_aggregate.aggtranstype => pg_catalog.pg_type.oid
48+
Join pg_catalog.pg_am.amkeytype => pg_catalog.pg_type.oid
4649
Join pg_catalog.pg_am.aminsert => pg_catalog.pg_proc.oid
4750
Join pg_catalog.pg_am.ambeginscan => pg_catalog.pg_proc.oid
4851
Join pg_catalog.pg_am.amgettuple => pg_catalog.pg_proc.oid
49-
Join pg_catalog.pg_am.amgetmulti => pg_catalog.pg_proc.oid
52+
Join pg_catalog.pg_am.amgetbitmap => pg_catalog.pg_proc.oid
5053
Join pg_catalog.pg_am.amrescan => pg_catalog.pg_proc.oid
5154
Join pg_catalog.pg_am.amendscan => pg_catalog.pg_proc.oid
5255
Join pg_catalog.pg_am.ammarkpos => pg_catalog.pg_proc.oid
@@ -125,6 +128,23 @@ Join pg_catalog.pg_statistic.staop3 => pg_catalog.pg_operator.oid
125128
Join pg_catalog.pg_tablespace.spcowner => pg_catalog.pg_authid.oid
126129
Join pg_catalog.pg_trigger.tgrelid => pg_catalog.pg_class.oid
127130
Join pg_catalog.pg_trigger.tgfoid => pg_catalog.pg_proc.oid
131+
Join pg_catalog.pg_ts_config.cfgnamespace => pg_catalog.pg_namespace.oid
132+
Join pg_catalog.pg_ts_config.cfgowner => pg_catalog.pg_authid.oid
133+
Join pg_catalog.pg_ts_config.cfgparser => pg_catalog.pg_ts_parser.oid
134+
Join pg_catalog.pg_ts_config_map.mapcfg => pg_catalog.pg_ts_config.oid
135+
Join pg_catalog.pg_ts_config_map.mapdict => pg_catalog.pg_ts_dict.oid
136+
Join pg_catalog.pg_ts_dict.dictnamespace => pg_catalog.pg_namespace.oid
137+
Join pg_catalog.pg_ts_dict.dictowner => pg_catalog.pg_authid.oid
138+
Join pg_catalog.pg_ts_dict.dicttemplate => pg_catalog.pg_ts_template.oid
139+
Join pg_catalog.pg_ts_parser.prsnamespace => pg_catalog.pg_namespace.oid
140+
Join pg_catalog.pg_ts_parser.prsstart => pg_catalog.pg_proc.oid
141+
Join pg_catalog.pg_ts_parser.prstoken => pg_catalog.pg_proc.oid
142+
Join pg_catalog.pg_ts_parser.prsend => pg_catalog.pg_proc.oid
143+
Join pg_catalog.pg_ts_parser.prsheadline => pg_catalog.pg_proc.oid
144+
Join pg_catalog.pg_ts_parser.prslextype => pg_catalog.pg_proc.oid
145+
Join pg_catalog.pg_ts_template.tmplnamespace => pg_catalog.pg_namespace.oid
146+
Join pg_catalog.pg_ts_template.tmplinit => pg_catalog.pg_proc.oid
147+
Join pg_catalog.pg_ts_template.tmpllexize => pg_catalog.pg_proc.oid
128148
Join pg_catalog.pg_type.typnamespace => pg_catalog.pg_namespace.oid
129149
Join pg_catalog.pg_type.typowner => pg_catalog.pg_authid.oid
130150
Join pg_catalog.pg_type.typrelid => pg_catalog.pg_class.oid
@@ -136,6 +156,7 @@ Join pg_catalog.pg_type.typreceive => pg_catalog.pg_proc.oid
136156
Join pg_catalog.pg_type.typsend => pg_catalog.pg_proc.oid
137157
Join pg_catalog.pg_type.typmodin => pg_catalog.pg_proc.oid
138158
Join pg_catalog.pg_type.typmodout => pg_catalog.pg_proc.oid
159+
Join pg_catalog.pg_type.typanalyze => pg_catalog.pg_proc.oid
139160
Join pg_catalog.pg_type.typbasetype => pg_catalog.pg_type.oid
140161

141162
---------------------------------------------------------------------------

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp