Re: BUG #1756: PQexec eats huge amounts of memory - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1756: PQexec eats huge amounts of memory
Date
Msg-id 13620.1121344707@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1756: PQexec eats huge amounts of memory  ("Denis Vlasenko" <vda@ilport.com.ua>)
List pgsql-bugs
Denis Vlasenko <vda@ilport.com.ua> writes:
> On Wednesday 13 July 2005 17:43, Tom Lane wrote:
>> The reason it cannot be done transparently is that you would lose the
>> guarantee that a query either succeeds or fails: it would be entirely
>> possible to return some rows to the application and only later get a
>> failure.

> What failures are likely?

Consider
    select x, 1/x from foo;

where x is zero in the 10,000'th row ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "THILANKA"
Date:
Subject: BUG #1767: Trigger handling
Next
From: "marco_0160"
Date:
Subject: [postgres] Betrifft: Datumsfeld leer lassen