aboutsummaryrefslogtreecommitdiff
path: root/src/tools/findoidjoins/findoidjoins.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/tools/findoidjoins/findoidjoins.c')
-rw-r--r--src/tools/findoidjoins/findoidjoins.c4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/tools/findoidjoins/findoidjoins.c b/src/tools/findoidjoins/findoidjoins.c
index cbb7b59adc8..21a09ada4f6 100644
--- a/src/tools/findoidjoins/findoidjoins.c
+++ b/src/tools/findoidjoins/findoidjoins.c
@@ -63,7 +63,9 @@ main(int argc, char **argv)
"pg_catalog.pg_namespace n WHERE n.oid = c.relnamespace) AS nspname "
"FROM pg_catalog.pg_class c "
"WHERE c.relkind = " CppAsString2(RELKIND_RELATION)
- " AND c.relhasoids "
+ " AND EXISTS(SELECT * FROM pg_attribute a"
+ " WHERE a.attrelid = c.oid AND a.attname = 'oid' "
+ " AND a.atttypid = 'oid'::regtype)"
"ORDER BY nspname, c.relname"
);