Add btree and hash opclasses for pg_lsn.
Tom Lane <tgl@sss.pgh.pa.us>
Add btree and hash opclasses for pg_lsn. This is needed to allow ORDER BY, DISTINCT, etc to work as expected for pg_lsn values. We had previously decided to put this off for 9.5, but in view of commit eeca4cd35e284c72b2ea1b4494e64e7738896e81 there's no reason to avoid a catversion bump for 9.4beta2, and this does make a pretty significant usability difference for pg_lsn. Michael Paquier, with fixes from Andres Freund and Tom Lane
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/pg_lsn.c | modified | +26 −2 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_amop.h | modified | +12 −0 |
| src/include/catalog/pg_amproc.h | modified | +2 −0 |
| src/include/catalog/pg_opclass.h | modified | +2 −0 |
| src/include/catalog/pg_operator.h | modified | +1 −1 |
| src/include/catalog/pg_opfamily.h | modified | +2 −0 |
| src/include/catalog/pg_proc.h | modified | +4 −0 |
| src/include/utils/pg_lsn.h | modified | +2 −0 |
| src/test/regress/expected/pg_lsn.out | modified | +130 −0 |
| src/test/regress/sql/pg_lsn.sql | modified | +14 −0 |