| From: | Roger Niederland <roger(at)niederland(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: variable not found in subplan target list |
| Date: | 2011-11-02 04:49:35 |
| Message-ID: | 4EB0CBDF.3090305@niederland.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/1/2011 8:30 PM, Tom Lane wrote:
> Roger Niederland<roger(at)niederland(dot)com> writes:
>> I extracted the tables from the database which generates the error above
>> I eliminated most of the columns such that this query still exhibits
>> this behavior to reduce
>> the file size. I have a zipped file from windows postgresql 9.1.1
>> (32-bit) which is about 1.5MBytes.
>> I verified that the database generated from this file will produce the
>> error.
> If you'd send that to me off-list, I'd be happy to take a look.
>
> regards, tom lane
>
>
>
I stripped enough out of the database that it is only good for a test
case. Here is a public
url for getting at the database backup:
http://dl.dropbox.com/u/13814973/test2.zip
The sql I posted earlier can be used on this to generate the error.
Thanks for taking a look at this!
Roger
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mohamed Hashim | 2011-11-02 07:12:20 | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |
| Previous Message | Royce Ausburn | 2011-11-02 04:27:30 | Re: Subselects in select expressions |