Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1169: Select table.oid from view seems to loop - Mailing list pgsql-bugs

From Robert Osowiecki
Subject Re: BUG #1169: Select table.oid from view seems to loop
Date
Msg-id 40D1BE58.9050005@cavern.pl
Whole thread Raw
In response to Re: BUG #1169: Select table.oid from view seems to loop  (Richard Huxton <dev@archonet.com>)
List pgsql-bugs
Tree view 
Richard Huxton wrote:

> In 7.4 there is a postgresql.conf setting to control this behaviour
> (add_missing_from). I'd turn it off, as I've always found it to cause
> problems rather than solve them.

I agree :)
PG now reports "ERROR: missing from clause", I've added "table1.oid" do
view definition
and everything works fine.

Thanks for your support and have a nice day!

Robson.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Fwd: Bug#255208: postgresql - ignores SIGPIPE]
Next
From: "Jim Helm"
Date:
Subject: Re: BUG #1167: POSIX getpwuid_r 4arg vs 5arg issue