From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: " Adding missing FROM-clause entry for table .... " problem.
Date: Tue, 18 Feb 2003 10:40:10 -0500
Message-ID: <23712.1045582810@sss.pgh.pa.us> (raw)
In-Reply-To: <3E520F93.4000002@klaster.net>
References: <3E520C32.CD9C82FA@rodos.fzk.de>
<3E520F93.4000002@klaster.net>
Tomasz Myrta <jasiek@klaster.net> writes:
> Christoph Haller wrote:
>> is not valid SQL syntax. What will actually happen (this is a PostgreSQL
>> extension to the standard) is that an implicit table
>> reference is added to the FROM clause, so the query is processed as if
>> it were written as
> I think this extension should be removed.
I don't think it's likely to get removed any time soon.
Maybe a workable compromise would be to add a GUC parameter
"allow_implicit_from", with options "ok" (completely permissive),
"notice" (the current behavior), and "error" (disallow it).
But we'd have to do something about the DELETE syntax before the
"error" setting would be real useful.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, jasiek@klaster.net, ch@rodos.fzk.de
Subject: Re: " Adding missing FROM-clause entry for table .... " problem.
In-Reply-To: <23712.1045582810@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox