delta/postgresql.git/contrib/rtree_gist/sql/rtree_gist.sql, branch master

Remove contrib version of rtree_gist --- now in core system.

2005-07-01T19:23:07+00:00

SET autocommit no longer needed in /contrib because pg_regress.sh does

2002-10-21T01:42:14+00:00

it automatically now on regression session startup.

Update /contrib for "autocommit TO 'on'".

2002-10-18T18:41:22+00:00

Create objects in public schema.

Make spacing/capitalization consistent.

Remove transaction block use for object creation.

Remove unneeded function GRANTs.

Update GiST for new pg_opclass arrangement (finally a clean solution

2001-08-22T18:24:26+00:00

for haskeytype).  Update GiST contrib modules too.  Add linear-time split
algorithm for R-tree GiST opclass.
From Oleg Bartunov and Teodor Sigaev.

Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions in

2001-08-21T16:36:06+00:00

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.

Support for emulating RTREE indexing in GiST. Contributed by

2001-05-31T18:27:18+00:00

Oleg Bartunov and Teodor Sigaev.