cannot find source of "add missing from" error

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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