How do I disable: Adding missing FROM-clause

From: <terry(at)ashtonwoodshomes(dot)com>
To: "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: How do I disable: Adding missing FROM-clause
Date: 2004-09-23 16:31:12
Message-ID: 013a01c4a18a$bdfdc460$2766f30a@development.greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know that PSQL has the cool feature of doing: Adding missing FROM-clause

But I want to disable it, because its silent adding can allow a bad SQL statement to execute a
cartesian select (when in fact it should error out).

I searched and found references to changing the postgresql.conf with:
add_missing_from = false
enable_implicited_join = false

But neither one of these seems to disable the functionality (I did a reload after making the change)

Do I have to completely stop the db to make the change? Or is there something else I should be
doing to disable it?

Thanks

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-23 16:55:40 Re: How do I disable: Adding missing FROM-clause
Previous Message Tom Lane 2004-09-23 16:22:53 Re: Réf. : Re: v8 on AIX5.2