Re: GiST support for UUIDs
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Paul A Jungwirth <pj@illuminatedcomputing.com>
Cc: pgsql-hackers@postgresql.org
Date: 2015-06-25T15:06:31Z
Lists: pgsql-hackers
Paul A Jungwirth <pj@illuminatedcomputing.com> writes: > I'm interested in adding GiST support for the UUID column type from > the uuid-ossp extension. This has been requested and attempted before: > I've used Postgres for a long time, but I've only dabbled a bit in the > source code. So I'm curious where this change would go? The btree_gist > extension? The uuid-ossp extension? Somewhere else? btree_gist, I'd think, assuming you are only thinking of btree-equivalent semantics and not anything more outre. uuid-ossp is only concerned with UUID generation algorithms, not with storage or indexing. btree_gist already has a bunch of infrastructure for this type of GiST opclass, so it should be pretty straightforward to add it there (at least up to making it work; the overhead of an extension version bump will probably exceed the useful payload :-( ). regards, tom lane
Commits
-
Test all contrib-created operator classes with amvalidate.
- ade49c605f1d 10.0 landed
-
Add uuid to the set of types supported by contrib/btree_gist.
- 11da83a0e70d 10.0 landed
-
Allow CREATE EXTENSION to follow extension update paths.
- 40b449ae84dc 10.0 cited