Re: variable not found in subplan target list? + test case

From: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: variable not found in subplan target list? + test case
Date: 2003-11-26 01:46:35
Message-ID: 3FC405FB234.A532KG@129.180.47.120
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, 25 Nov 2003 19:02:54 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au> writes:
> >> Can you send a test case with table and view definitions, it's hard to
> >> generate one from just the information above.
>
> > ok. the last select generates the error.
>
> Hoo, that was a fun one. Here's the patch.
>
> regards, tom lane
>

works on linux and cygwin.

thanks for the fix.

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg(at)kgb(dot)une(dot)edu(dot)au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2003-11-26 06:41:46 Re: Fwd: Solaris build of 7.4 problem with
Previous Message Tom Lane 2003-11-26 00:45:23 Re: SELECT with MANY tables