X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DF6F5DB929 for ; Fri, 18 Nov 2005 08:15:32 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12075-03 for ; Fri, 18 Nov 2005 12:15:34 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 625FBDB97F for ; Fri, 18 Nov 2005 08:15:28 -0400 (AST) Received: (qmail invoked by alias); 18 Nov 2005 12:15:31 -0000 Received: from dslb-084-063-010-016.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.10.16] by mail.gmx.net (mp029) with SMTP; 18 Nov 2005 13:15:31 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: Diego Subject: Re: Version 8.1 Date: Fri, 18 Nov 2005 13:15:28 +0100 User-Agent: KMail/1.8.2 Cc: pgsql-admin@postgresql.org References: <437DCA76.2090900@unimedijui.com.br> In-Reply-To: <437DCA76.2090900@unimedijui.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200511181315.28870.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/238 X-Sequence-Number: 19611 Diego wrote: > Why donīt work in 8.1? Because it is violating the SQL standard and 8.1 is stricter in that regard. > ERROR: missing FROM-clause entry for table "tabpes" So add that table to the FROM clause. -- Peter Eisentraut http://developer.postgresql.org/~petere/