Joe Conway <[EMAIL PROTECTED]> writes:
> replica=# create table foo(f1 int);
> CREATE TABLE
> replica=# SELECT * FROM foo t WHERE NOT EXISTS (SELECT remoteid FROM (SELECT
> f1 as remoteid FROM foo WHERE f1 = t.f1) AS t1);
> server closed the connection unexpectedly
Got it --- this bug has been th
Joe Conway <[EMAIL PROTECTED]> writes:
> replica=# create table foo(f1 int);
> CREATE TABLE
> replica=# SELECT * FROM foo t WHERE NOT EXISTS (SELECT remoteid FROM (SELECT
> f1 as remoteid FROM foo WHERE f1 = t.f1) AS t1);
> server closed the connection unexpectedly
Ick.
> I'm just starting to di
Joe Conway wrote:
> Oleg Lebedev wrote:
>
>> Ok, here are all the files.
>>
This dblink thread on GENERAL led me to a bug in the planner subselect code.
Here is an example query that triggers it (independent of dblink and/or table
functions):
replica=# create table foo(f1 int);
CREATE TABLE
