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
PostgreSQL Bugs List wrote:
The following bug has been logged online:
Bug reference: 1169
Logged by: Robert Osowiecki
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux
Description:Select table.oid from view seems to loop
Here's what i fou
On Thu, 17 Jun 2004, PostgreSQL Bugs List wrote:
> Description:Select table.oid from view seems to loop
>
> Details:
>
> Hello!
>
> Here's what i found:
>
> select count(*) from view1;
> count
> ---
> 12874
> (1 row)
>
> select table1.oid from view1;
> NOTICE: adding missing FROM-cl
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> select table1.oid from view1;
> NOTICE: adding missing FROM-clause entry for table "table1"
^^^
This is an unqualified join, and will yield count(table1)*count(view1)
rows. table1.oid
The following bug has been logged online:
Bug reference: 1169
Logged by: Robert Osowiecki
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux
Description:Select table.oid from view seems to loop
Details:
Hello!
Here's what i found:
