Thread: "Adding missing from clause"
PG Folks, Could we have a .conf option to turn OFF the "Adding Missing From Clause for Table ... "? I'd far rather have a fatal query error than have Postgres automatically insert the tables it thinks I wanted. This automated adding in tables also seems very inconsistent with Postgres' dedication to accuracy above all. Apologies if this is already taken care of in 7.4. -- -Josh BerkusAglio Database SolutionsSan Francisco
Josh Berkus <josh@agliodbs.com> writes:
> Could we have a .conf option to turn OFF the "Adding Missing From Clause for
> Table ... "?
No objection here. Send a patch.
regards, tom lane
At 02:36 PM 29/04/2003 -0700, Josh Berkus wrote: >I'd far rather have a fatal query error than have Postgres >automatically insert the tables it thinks I wanted I too would dearly like to see this. ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 03 5330 3172 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
Added to TODO: * Add config variable to prevent auto-adding missing FROM-clause tables --------------------------------------------------------------------------- Philip Warner wrote: > At 02:36 PM 29/04/2003 -0700, Josh Berkus wrote: > >I'd far rather have a fatal query error than have Postgres > >automatically insert the tables it thinks I wanted > > I too would dearly like to see this. > > > ---------------------------------------------------------------- > Philip Warner | __---_____ > Albatross Consulting Pty. Ltd. |----/ - \ > (A.B.N. 75 008 659 498) | /(@) ______---_ > Tel: (+61) 0500 83 82 81 | _________ \ > Fax: (+61) 03 5330 3172 | ___________ | > Http://www.rhyme.com.au | / \| > | --________-- > PGP key available upon request, | / > and from pgp5.ai.mit.edu:11371 |/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
And patch now in queue. :-) --------------------------------------------------------------------------- Bruce Momjian wrote: > > Added to TODO: > > * Add config variable to prevent auto-adding missing FROM-clause > tables > > > --------------------------------------------------------------------------- > > Philip Warner wrote: > > At 02:36 PM 29/04/2003 -0700, Josh Berkus wrote: > > >I'd far rather have a fatal query error than have Postgres > > >automatically insert the tables it thinks I wanted > > > > I too would dearly like to see this. > > > > > > ---------------------------------------------------------------- > > Philip Warner | __---_____ > > Albatross Consulting Pty. Ltd. |----/ - \ > > (A.B.N. 75 008 659 498) | /(@) ______---_ > > Tel: (+61) 0500 83 82 81 | _________ \ > > Fax: (+61) 03 5330 3172 | ___________ | > > Http://www.rhyme.com.au | / \| > > | --________-- > > PGP key available upon request, | / > > and from pgp5.ai.mit.edu:11371 |/ > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073