Re: [GENERAL] cannot find source of "add missing from" error

2005-12-07 Thread Karsten Hilbert
On Wed, Dec 07, 2005 at 01:50:37PM +0100, Martijn van Oosterhout wrote: > > from > > v_basic_person vbp<-- > > where > > hxfi.fk_relative = v_basic_person.pk_identity <--- Duh. It got to be something simple which I just couldn't see. Thank

Re: [GENERAL] cannot find source of "add missing from" error

2005-12-07 Thread Martijn van Oosterhout
On Wed, Dec 07, 2005 at 10:10:40AM +0100, Karsten Hilbert wrote: > 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 fo

[GENERAL] cannot find source of "add missing from" error

2005-12-07 Thread Karsten Hilbert
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 o