summaryrefslogtreecommitdiff
path: root/contrib/findoidjoins/findoidjoins.c
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>1998-09-14 01:14:49 +0000
committerBruce Momjian <bruce@momjian.us>1998-09-14 01:14:49 +0000
commit37009811083291f059a0ae1eea955fc7e329ffca (patch)
tree880f9b709b58845fc421901e9ff15f7cbfd19e0b /contrib/findoidjoins/findoidjoins.c
parentf1bcb171e879af8026045922181d58953de5a489 (diff)
downloadpostgresql-37009811083291f059a0ae1eea955fc7e329ffca.tar.gz
Add new make_oidjoin_check utility and template1_check.sql. Fix some
pg_operator problems.
Diffstat (limited to 'contrib/findoidjoins/findoidjoins.c')
-rw-r--r--contrib/findoidjoins/findoidjoins.c2
1 files changed, 2 insertions, 0 deletions
diff --git a/contrib/findoidjoins/findoidjoins.c b/contrib/findoidjoins/findoidjoins.c
index b1178b5834..6c0e2e19d1 100644
--- a/contrib/findoidjoins/findoidjoins.c
+++ b/contrib/findoidjoins/findoidjoins.c
@@ -35,6 +35,7 @@ main(int argc, char **argv)
FROM pg_class c, pg_attribute a, pg_type t \
WHERE a.attnum > 0 AND \
relkind = 'r' AND \
+ relhasrules = 'f' AND \
(typname = 'oid' OR \
typname = 'regproc') AND \
a.attrelid = c.oid AND \
@@ -49,6 +50,7 @@ main(int argc, char **argv)
SELECT relname \
FROM pg_class c \
WHERE relkind = 'r' AND \
+ relhasrules = 'f' AND \
relname != 'pg_user' \
ORDER BY 1; \
");