Postgres Pro
Downloads
Home   >   mailing lists

Re: Outer joins in views - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Outer joins in views
Date
Msg-id 6644.975960613@sss.pgh.pa.us
Whole thread Raw
In response to Outer joins in views  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> In the 7.1 devel version, the OUTER JOIN statementes are working, but
> not in VIEWs. I have created the below listed view, and while it
> allows to be created, any attempt of using it ends with:
> ERROR: Internal error: no jointree entry for rel *OLD*

Thanks for the report.  However, I can't easily reproduce it with just
the CREATE VIEW command.  Could I have CREATE TABLE statements for the
referenced tables, too, please?

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: initdb on Alpha dies with spinlock errors
Next
From: Tom Lane
Date:
Subject: Re: initdb on Alpha dies with spinlock errors