Re: ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join

--0-467593101-1213704601=:95297
Content-Type: text/plain; charset=us-ascii

--- On Tue, 6/17/08, Jaime Casanova <systemguards@[EMAIL PROTECTED]
 wrote:

maybe the add_missing_from parameter in postgresql.conf is what you
need to get some sleep :)
it's there for older application like yours


Dear Jaime,

Tommy's suggestion worked right away. I wanted to 
understand more of the philiosphy behind what you wrote.

Looking around, I just found many references to changes like this
 
From: Neil Conway <neilc(at)samurai(dot)com>To: pgsql-patches
<pgsql-patches(at)postgresql(dot)org>Subject: add_missing_from =
falseDate: Thu, 07 Apr 2005 17:04:26 +1000






Now that DELETE has a USING clause, we should be able to make 
add_missing_from=false the default in 8.1; the attached patch implements 
this and updates the do***entation.
Barring any objections, I'll apply this tomorrow.

 Is there a canonical place to read more about this issue?

Thank you all so much!!!!!
Mitchell



      
--0-467593101-1213704601=:95297
Content-Type: text/html; charset=us-ascii

<table cellspacing='0' cellpadding='0' border='0' background='none'
style='font-family:arial;font-size:10pt;color:rgb(51, 51,
51);background-color:rgb(255, 255, 255);width:100%;'><tr><td valign='top'
style='font: inherit;'>--- On <b>Tue, 6/17/08, Jaime Casanova
<i>&lt;systemguards@[EMAIL PROTECTED]
></b> wrote:<br><blockquote
style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px;
padding-left: 5px;"><pre><br>maybe the add_missing_from parameter in
postgresql.conf is what you<br>need to get some sleep :)<br>it's there for
older application like yours<br><br><br>Dear Jaime,<br><br>Tommy's
suggestion worked right away. I wanted to <br>understand more of the
philiosphy behind what you wrote.<br><br>Looking around, I just found many
references to changes like
this<br>&nbsp;<br></pre><ul><li><strong>From</strong>: Neil Conway &lt;<a
href="mailto:neilc@[EMAIL PROTECTED]
">neilc(at)samurai(dot)com</a>&gt;</li><li><strong>To</strong>:
pgsql-patches &lt;<a

href="mailto:pgsql-patches@[EMAIL PROTECTED]
">pgsql-patches(at)postgresql(dot)org</a>&gt;</li><li><strong>Subject</strong>:
add_missing_from = false</li><li><strong>Date</strong>: Thu, 07 Apr 2005
17:04:26 +1000</li></ul>
<!--/noindex-->
<!--X-Head-of-Message-End-->
<!--X-Head-Body-Sep-Begin-->
<hr>
<!--X-Head-Body-Sep-End-->
<!--X-Body-of-Message-->
<tt>Now that DELETE has a USING clause, we should be able to make 
</tt><tt>add_missing_from=false the default in 8.1; the attached patch
implements 
</tt><tt>this and updates the do***entation.
</tt>Barring any objections, I'll apply this tomorrow.

<pre> Is there a canonical place to read more about this
issue?<br><br>Thank you all so
much!!!!!<br>Mitchell<br></pre></blockquote></td></tr></table><br>



      
--0-467593101-1213704601=:95297--