Re: add_missing_from in 8.1 - Mailing list pgsql-hackers

From Euler Taveira de Oliveira
Subject Re: add_missing_from in 8.1
Date
Msg-id 20050331164727.49294.qmail@web54605.mail.yahoo.com
Whole thread Raw
In response to add_missing_from in 8.1  (Neil Conway <neilc@samurai.com>)
Responses Re: add_missing_from in 8.1  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: add_missing_from in 8.1  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
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.


Euler Taveira de Oliveira
euler[at]yahoo_com_br

    
Yahoo! Acesso Grátis - Internet rápida e grátis. 
Instale o discador agora! http://br.acesso.yahoo.com/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: _RollbackFunc : dead code?
Next
From: Bruce Momjian
Date:
Subject: Re: add_missing_from in 8.1