Re: [PATCHES] DELETE ... USING

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073