Revision - 9a743ff - Fix bugs in information_schema.referential_constraints view. - origin: https://github.com/postgres/postgres

visit type:

https://github.com/postgres/postgres

07 April 2024, 13:56:23 UTC

Revision 9a743ffdd6b2fe7a24089fc97d8efc98884e337d authored by Tom Lane on 15 October 2011, 00:24:57 UTC, committed by Tom Lane on 15 October 2011, 00:24:57 UTC

Fix bugs in information_schema.referential_constraints view.

This view was being insufficiently careful about matching the FK constraint
to the depended-on primary or unique key constraint.  That could result in
failure to show an FK constraint at all, or showing it multiple times, or
claiming that it depended on a different constraint than the one it really
does.  Fix by joining via pg_depend to ensure that we find only the correct
dependency.

Back-patch, but don't bump catversion because we can't force initdb in back
branches.  The next minor-version release notes should explain that if you
need to fix this in an existing installation, you can drop the
information_schema schema then re-create it by sourcing
$SHAREDIR/information_schema.sql in each database (as a superuser of
course).

1 parent 7a0c584

Files
Changes

Permalinks

Tip revision: 9a743ffdd6b2fe7a24089fc97d8efc98884e337d authored by Tom Lane on 15 October 2011, 00:24:57 UTC
Fix bugs in information_schema.referential_constraints view.

Tip revision: 9a743ff

File	Mode	Size
TODO.detail
src
FAQ	-rw-r--r--	37.2 KB
FAQ_AIX	-rw-r--r--	17.6 KB
FAQ_CYGWIN	-rw-r--r--	4.0 KB
FAQ_DEV	-rw-r--r--	114 bytes
FAQ_HPUX	-rw-r--r--	3.5 KB
FAQ_IRIX	-rw-r--r--	2.4 KB
FAQ_MINGW	-rw-r--r--	2.4 KB
FAQ_SCO	-rw-r--r--	6.7 KB
FAQ_Solaris	-rw-r--r--	5.5 KB
FAQ_brazilian	-rw-r--r--	41.3 KB
FAQ_chinese_simp	-rw-r--r--	29.1 KB
FAQ_chinese_trad	-rw-r--r--	28.9 KB
FAQ_czech	-rw-r--r--	47.5 KB
FAQ_farsi	-rw-r--r--	140.6 KB
FAQ_french	-rw-r--r--	59.1 KB
FAQ_german	-rw-r--r--	62.2 KB
FAQ_hungarian	-rw-r--r--	47.6 KB
FAQ_japanese	-rw-r--r--	44.5 KB
FAQ_polish	-rw-r--r--	57.3 KB
FAQ_russian	-rw-r--r--	43.5 KB
FAQ_turkish	-rw-r--r--	51.3 KB
KNOWN_BUGS	-rw-r--r--	164 bytes
MISSING_FEATURES	-rw-r--r--	164 bytes
Makefile	-rw-r--r--	3.0 KB
README.mb.big5	-rw-r--r--	9.8 KB
README.mb.jp	-rw-r--r--	33.2 KB
TODO	-rw-r--r--	53.3 KB
bug.template	-rw-r--r--	1.5 KB

Showing with 0 additions and 0 deletions (0 / 0 diffs computed)

Computing file changes ...

https://github.com/postgres/postgres

Fix bugs in information_schema.referential_constraints view.

README.mb.big5