diff options
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; \ "); |