Skip site navigation (1) Skip section navigation (2)

Re: add_missing_from in 8.1

From: Euler Taveira de Oliveira <eulerto(at)yahoo(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add_missing_from in 8.1
Date: 2005-03-31 16:47:26
Message-ID: 20050331164727.49294.qmail@web54605.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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/

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-03-31 17:30:25
Subject: Re: add_missing_from in 8.1
Previous:From: Tom LaneDate: 2005-03-31 16:32:27
Subject: Re: _RollbackFunc : dead code?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group