Re: [PATCHES] DELETE ... USING - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] DELETE ... USING
Date
Msg-id 200504090418.j394IrW16352@candle.pha.pa.us
Whole thread Raw
Responses Re: [PATCHES] DELETE ... USING
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >     test=> SELECT pg_class.* LIMIT 0;
> >     NOTICE:  adding missing FROM-clause entry for table "pg_class"
> 
> > Is this what we want?  I don't think so.  I thought we wanted to
> > maintain the backward-compatible syntax of no FROM clause.
> 
> Well, the discussion earlier in the week concluded that
> add_missing_from=true should emit a notice in every case where
> add_missing_from=false would fail.  Do you want to argue against
> that conclusion?

I didn't realize that "SELECT pg_class.*" was now going to fail because
add_missing_from is false.  I didn't link those two together in my head,
probably because the warning is not emitted if there is no FROM clause.

Anyway, I am fine either way but wanted to publicise it at least.

--  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
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] DELETE ... USING
Next
From: Neil Conway
Date:
Subject: Re: Optimizing maximum/minimum queries (yet again)