diff options
| author | Bruce Momjian <bruce@momjian.us> | 1998-09-14 01:14:49 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1998-09-14 01:14:49 +0000 |
| commit | 37009811083291f059a0ae1eea955fc7e329ffca (patch) | |
| tree | 880f9b709b58845fc421901e9ff15f7cbfd19e0b /contrib/findoidjoins/findoidjoins.c | |
| parent | f1bcb171e879af8026045922181d58953de5a489 (diff) | |
| download | postgresql-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.c | 2 |
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; \ "); |
