Re: New warning code for missing FROM relations - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: New warning code for missing FROM relations
Date
Msg-id 200006041736.NAA20256@candle.pha.pa.us
Whole thread Raw
In response to Re: New warning code for missing FROM relations  ("Zeugswetter Andreas" <andreas.zeugswetter@telecom.at>)
List pgsql-hackers
> > > If the goal is (a) then your way is better, but I like mine if the goal
> > > is (b).  Seems like some discussion is needed here about just what we
> > > want to accomplish.
> > 
> > I agree the goal is (b).  However, I can not imagine a query with a FROM
> > clause that would ever want to use auto-creation of range entries.
> 
> how about:
> 
> delete from taba where a=tabb.a; 
> 
> I think the implicit auto-creation should only be disallowed/warned in 
> select statements that have a from clause, not update and delete.

I meant a SELECT FROM clause.  A DELETE FROM is not the same, and does
not mark the entry as inFromCl.  I should have been more specific.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: PG 7.0 crash on SELECT
Next
From: Bruce Momjian
Date:
Subject: Re: New warning code for missing FROM relations