> I have a view:
>
> create or replace view addenda as
> select
> documents.id,
> documents.oid,
> documents.projects_id,
> documents.doc_num,
> documents.description,
> documents.date,
> documents.createdate,
> documents.moddate,
> documents.people_id,
> documents.parent,
> documents.document_type,
> documents.state,
> documents.machines_id,
> documents.phases_id,
>
> d_addenda.item_num,
> d_addenda.drawing_reference
>
> from
> d_addenda as a, documents as d
> where a.documents_id = d.id;
>
Doing this you should have got
NOTICE: Adding missing FROM-clause entry for table "d_addenda"
NOTICE: Adding missing FROM-clause entry for table "documents"
So it's pretty useful to write psql's output to a file when creating
relations
and check for NOTICE messages.
exec 3>/tmp/psql.out;$PGSQLD/bin/psql <your options here> 1>&3 2>&3
NOTICE messages appear to be sent to stderr.
As the previous posters already made clear
create or replace view addenda as
select
documents.id,
documents.oid,
documents.projects_id,
documents.doc_num,
documents.description,
documents.date,
documents.createdate,
documents.moddate,
documents.people_id,
documents.parent,
documents.document_type,
documents.state,
documents.machines_id,
documents.phases_id,
d_addenda.item_num,
d_addenda.drawing_reference
from
d_addenda , documents
where d_addenda.documents_id = documents.id;
resp.
create or replace view addenda as
select
d.id,
d.oid,
d.projects_id,
d.doc_num,
d.description,
d.date,
d.createdate,
d.moddate,
d.people_id,
d.parent,
d.document_type,
d.state,
d.machines_id,
d.phases_id,
a.item_num,
a.drawing_reference
from
d_addenda as a, documents as d
where a.documents_id = d.id;
should match your intentions.
Regards, Christoph
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
