Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote:
>> Unfortunately I do not understand why PostgreSQL says
>>
>> psql:xx.sql:14: ERROR: could not implement UNION
>> DETAIL: Some of the datatypes only support hashing, while others only support sorting.
> The solution lies in these bits:
>> pk_context | integer[] |
> This data type can only be hashed.
>> xmin_message_inbox | xid |
> This data type can only be sorted.
ITYM the other way round, right?
As of 9.1 there will be support for hashing arrays, so this particular
problem should go away without hacks.
regards, tom lane
