Re: v7.1 error ... SELECT converted to a COPY?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: v7.1 error ... SELECT converted to a COPY?
Date: 2001-04-30 04:54:30
Message-ID: 10464.988606470@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> Okay, maybe this query isn't quite as simple as I think it is, but does
> this raise any flags for anyone? How did I get into a COPY? It appears
> re-creatable, as I've done it twice so far ...

> eceb=# select e.idnumber,e.password from egi e, auth_info a where e.idnumber != a.idnumber;
> Backend sent D message without prior T
> Backend sent D message without prior T

At a guess, you're running out of memory on the client side for the
SELECT results (did you really want a not-equal rather than equal
constraint there!?) --- libpq tends not to cope with this too
gracefully. Someone oughta fix that...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2001-04-30 04:57:57 Re: v7.1 error ... SELECT converted to a COPY?
Previous Message The Hermit Hacker 2001-04-30 04:37:15 v7.1 error ... SELECT converted to a COPY?