Re: Overlapping timestamptz ranges with priority

On 6/27/21 3:41 PM, Ray O'Donnell wrote: Hi all, I'm playing with timestamptz ranges for a hobby project. I have a table with a tstzrange column, in which the timestamps can overlap; where they do, rows with a higher priority (derived from a bigint primary key column) should be picked. What

Overlapping timestamptz ranges with priority

Hi all, I'm playing with timestamptz ranges for a hobby project. I have a table with a tstzrange column, in which the timestamps can overlap; where they do, rows with a higher priority (derived from a bigint primary key column) should be picked. What I'd like to do is present a view which sh

Re: GIN indexed unique constraint?

On Sun, Jun 27, 2021 at 9:41 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau > wrote: > >> Is it possible to declare a UNIQUE constraint that uses GIN indexing? > > > Doesn't seem to be possible. The btree_gin extension would provide the > > ne

Re: GIN indexed unique constraint?

"David G. Johnston" writes: > On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau wrote: >> Is it possible to declare a UNIQUE constraint that uses GIN indexing? > Doesn't seem to be possible. The btree_gin extension would provide the > necessary code but it states explicitly that: > "... and they lac

Re: GIN indexed unique constraint?

On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau wrote: > Is it possible to declare a UNIQUE constraint that uses GIN indexing? > > Doesn't seem to be possible. The btree_gin extension would provide the necessary code but it states explicitly that: "... and they lack one major feature of the standa

GIN indexed unique constraint?

Hi, Is it possible to declare a UNIQUE constraint that uses GIN indexing? If so, what would the definition look like? Allan.

Re: Ubuntu 14.04 (trusty) Postgres 13 deb package

On 6/24/21 2:33 PM, Bhavesh Mistry wrote: Hi All, I was trying to install PSQL 13 on Ubuntu 14.04 (trusty)  but I could not find the package.  It seems the path has been removed.  Can you please tell me how to build deb package for trusty from psql source? I tried psql 13 sources, I was able

Ubuntu 14.04 (trusty) Postgres 13 deb package

Hi All, I was trying to install PSQL 13 on Ubuntu 14.04 (trusty) but I could not find the package. It seems the path has been removed. Can you please tell me how to build deb package for trusty from psql source? I tried psql 13 sources, I was able to build but I could not figure out how to buil