Re: Vector type (Re: challenging constraint situation - how do I make it) - Mailing list pgsql-general

From Tom Lane
Subject Re: Vector type (Re: challenging constraint situation - how do I make it)
Date
Msg-id 25551.1148652459@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vector type (Re: challenging constraint situation -  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: Vector type (Re: challenging constraint situation -
List pgsql-general
Alban Hertroys <alban@magproductions.nl> writes:
> I'd say "unique constraint violation" right here (provided there's a
> unique constraint on this column, of course). The order in which these
> are inserted/updated doesn't seem to matter either. I'm afraid I'm still
> missing the point...

The point is that btree depends on a number of assumptions about the
behavior of the operators in an operator class, and one of those
assumptions is that "equality" is transitive.

            regards, tom lane

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Vector type (Re: challenging constraint situation -
Next
From: Tom Lane
Date:
Subject: Re: Restricting access to rows?