Re: variable not found in subplan target list

Поиск
Список
Период
Сортировка
От Roger Niederland
Тема Re: variable not found in subplan target list
Дата
Msg-id 4EB0CBDF.3090305@niederland.com
обсуждение исходный текст
Ответ на Re: variable not found in subplan target list  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: variable not found in subplan target list  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

On 11/1/2011 8:30 PM, Tom Lane wrote:
> Roger Niederland<roger@niederland.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


В списке pgsql-general по дате отправления:

Предыдущее
От: Royce Ausburn
Дата:
Сообщение: Re: Subselects in select expressions
Следующее
От: Chris Dumoulin
Дата:
Сообщение: select where not exists returning multiple rows?