Re: add_missing_from in 8.1

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Euler Taveira de Oliveira <eulerto(at)yahoo(dot)com(dot)br>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add_missing_from in 8.1
Date: 2005-03-31 17:30:25
Message-ID: 200503311730.j2VHUPA27743@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Euler Taveira de Oliveira wrote:
> Hi,
>
> > > I'd like to make add_missing_from=false the default for 8.1. Any
> > objections?
> >
> > We still don't have a solution for DELETE, do we?
> >
> Are you talking about DELETE FROM bar USING foo ? I submitted a patch
> some months ago.
> http://archives.postgresql.org/pgsql-patches/2004-12/msg00169.php
> And IIRC I could be fine if we just disable add_missing_from like Neil
> suggest because if someone write the join incorrectly i'll lead to
> exclude all rows in the table.

Wow, seems I lost that somehow. I don't see it the 8.1 patches queue.
Let me add this email now so I don't lose it.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Crawford 2005-03-31 17:44:50 Re: Excessive growth of pg_attribute and other system tables
Previous Message Euler Taveira de Oliveira 2005-03-31 16:47:26 Re: add_missing_from in 8.1