| 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: | Whole Thread | Raw Message | 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
| 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 |