summaryrefslogtreecommitdiff
path: root/contrib/findoidjoins/findoidjoins.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>1999-03-26 07:21:58 +0000
committerTom Lane <tgl@sss.pgh.pa.us>1999-03-26 07:21:58 +0000
commit85e9e03e0b432dc7c4d029d0f2f0083db752f7c0 (patch)
tree62f573e4244fe7063d654654cb5e515e55bf2020 /contrib/findoidjoins/findoidjoins.c
parent1e117923aa03a58d3c4b55b84b564aeaf681449d (diff)
downloadpostgresql-85e9e03e0b432dc7c4d029d0f2f0083db752f7c0.tar.gz
Update findoidjoins for 6.5: remove workaround for long-dead bug,
use NOT EXISTS() which is a lot faster than NOT IN (), update documentation.
Diffstat (limited to 'contrib/findoidjoins/findoidjoins.c')
-rw-r--r--contrib/findoidjoins/findoidjoins.c3
1 files changed, 1 insertions, 2 deletions
diff --git a/contrib/findoidjoins/findoidjoins.c b/contrib/findoidjoins/findoidjoins.c
index 6c0e2e19d1..77e8c7475d 100644
--- a/contrib/findoidjoins/findoidjoins.c
+++ b/contrib/findoidjoins/findoidjoins.c
@@ -50,8 +50,7 @@ main(int argc, char **argv)
SELECT relname \
FROM pg_class c \
WHERE relkind = 'r' AND \
- relhasrules = 'f' AND \
- relname != 'pg_user' \
+ relhasrules = 'f' \
ORDER BY 1; \
");
doquery("FETCH ALL IN c_relations");