X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CDF7D11F609E for ; Fri, 28 Apr 2006 16:02:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 78670-10 for ; Fri, 28 Apr 2006 16:02:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 71DC211F607D for ; Fri, 28 Apr 2006 16:02:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3SJ2hLn015233; Fri, 28 Apr 2006 15:02:43 -0400 (EDT) To: Markus Schaber cc: PostgreSQL SQL List Subject: Re: Slightly confused error message In-reply-to: <44524310.70906@logix-tt.com> References: <44523BF1.1080307@logix-tt.com> <1612.1146240424@sss.pgh.pa.us> <44524310.70906@logix-tt.com> Comments: In-reply-to Markus Schaber message dated "Fri, 28 Apr 2006 18:30:08 +0200" Date: Fri, 28 Apr 2006 15:02:42 -0400 Message-ID: <15232.1146250962@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/210 X-Sequence-Number: 25019 Markus Schaber writes: > Yes, and my question is whether it is easy and worth the effort. to add > that information (about the acutally offending subquery) to the message. I'm not sure about localizing the subquery per se, but it might be possible to add a syntax pointer to the specific variable occurrence that it's complaining about. That would help at least somewhat in cases like this. regards, tom lane