diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-08-21 16:36:06 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-08-21 16:36:06 +0000 |
| commit | f933766ba7c5446a28d714904ae0c46d8b21b86a (patch) | |
| tree | 81c8ecd2a2f8161d91670f5325331ba1704c2ab7 /contrib/findoidjoins/findoidjoins.c | |
| parent | c2d156691292d7be998eacf5b99dce3ea3c29ab2 (diff) | |
Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions in
pgsql-hackers. pg_opclass now has a row for each opclass supported by each
index AM, not a row for each opclass name. This allows pg_opclass to show
directly whether an AM supports an opclass, and furthermore makes it possible
to store additional information about an opclass that might be AM-dependent.
pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we
previously expected the user to remember to provide in CREATE INDEX commands.
Lossiness is no longer an index-level property, but is associated with the
use of a particular operator in a particular index opclass.
Along the way, IndexSupportInitialize now uses the syscaches to retrieve
pg_amop and pg_amproc entries. I find this reduces backend launch time by
about ten percent, at the cost of a couple more special cases in catcache.c's
IndexScanOK.
Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane.
initdb forced.
Diffstat (limited to 'contrib/findoidjoins/findoidjoins.c')
| -rw-r--r-- | contrib/findoidjoins/findoidjoins.c | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/contrib/findoidjoins/findoidjoins.c b/contrib/findoidjoins/findoidjoins.c index 87d794a9da4..c559b7a3625 100644 --- a/contrib/findoidjoins/findoidjoins.c +++ b/contrib/findoidjoins/findoidjoins.c @@ -68,15 +68,17 @@ main(int argc, char **argv) if (strcmp(typname, "oid") == 0) sprintf(query, "\ DECLARE c_matches BINARY CURSOR FOR \ - SELECT count(*) \ + SELECT count(*)::int4 \ FROM \"%s\" t1, \"%s\" t2 \ - WHERE t1.\"%s\" = t2.oid ", relname, relname2, attname); + WHERE t1.\"%s\" = t2.oid ", + relname, relname2, attname); else sprintf(query, "\ DECLARE c_matches BINARY CURSOR FOR \ - SELECT count(*) \ - FROM \"%s\" t1, \"%s\" t2 \ - WHERE RegprocToOid(t1.\"%s\") = t2.oid ", relname, relname2, attname); + SELECT count(*)::int4 \ + FROM \"%s\" t1, \"%s\" t2 \ + WHERE RegprocToOid(t1.\"%s\") = t2.oid ", + relname, relname2, attname); doquery(query); doquery("FETCH ALL IN c_matches"); |