| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | problematic view definition |
| Date: | 2011-02-09 22:12:01 |
| Message-ID: | 20110209221201.GC2717@hermes.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all !
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
DETAIL: Some of the datatypes only support hashing, while others only support sorting.
when I say
select * from dem.v_message_inbox;
I mean, I (hope I) do understand what PostgreSQL tries to
tell me but I don't know how to find out which columns are
affected ...
Thanks !
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
| Attachment | Content-Type | Size |
|---|---|---|
| xtest.txt | text/plain | 19.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2011-02-09 22:29:29 | Re: XML Encoding problem |
| Previous Message | David Kerr | 2011-02-09 19:23:19 | Re: pg_dump: schema with OID 58698 does not exist |