Re: [GENERAL] problematic view definition

2011-02-20 Thread Karsten Hilbert
On Sun, Feb 20, 2011 at 02:31:46PM -0500, Tom Lane wrote: > Karsten Hilbert 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 th

Re: [GENERAL] problematic view definition

2011-02-20 Thread Tom Lane
Karsten Hilbert 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

Re: [GENERAL] problematic view definition

2011-02-20 Thread Karsten Hilbert
For the record: On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote: > Attached find some table and view definitions from the > GNUmed (www.gnumed.de) database. > > Unfortunately I do not understand why PostgreSQL says > > psql:xx.sql:14: ERROR: could not implement UNION >

Re: [GENERAL] problematic view definition

2011-02-09 Thread Karsten Hilbert
I should have mentioned this is on PostgreSQL 8.4.5 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-4) 4.4.5, 32-bit Karsten On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote: > Date: Wed, 9 Feb 2011 23:12:01 +0100 > From: Karsten Hilbert > To: pgsql-gene