| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | cannot find source of "add missing from" error |
| Date: | 2005-12-07 09:10:40 |
| Message-ID: | 20051207091038.GQ5968@merkur.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a slightly involved view that draws from other views.
Upon insertion into the database (creation) it complains of
ERROR: missing FROM-clause entry in subquery for table "v_basic_person"
and I can't for the life of it find why (I know I can work
around this with a postgresql.conf option).
The view that's erroring out and the view that's being
complained about is found in the attachments. The whole lot
of other tables and functions is found here:
http://savannah.gnu.org/cgi-bin/viewcvs/gnumed/gnumed/gnumed/server/sql/
(the function _() is found in gmI18N.sql BTW)
Can anyone help me pinpoint which relation is missing in
what FROM clause ?
(This project is a medical practice management system.)
Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
| Attachment | Content-Type | Size |
|---|---|---|
| v_hx_family.sql | text/plain | 3.0 KB |
| v_basic_person.sql | text/plain | 860 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Formación On-Line - Formabyte | 2005-12-07 09:19:59 | CURSOS FORMACIÓN INFORMATICA ONLINE |
| Previous Message | A. Kretschmer | 2005-12-07 09:07:01 | Re: MySQL dump |