From: | Andrew Chernow <ac(at)esilo(dot)com> |
---|---|
To: | Pavel Golub <pavel(at)gf(dot)microolap(dot)com> |
Cc: | Pavel Golub <pavel(at)microolap(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: PQdeleteTuple function in libpq |
Date: | 2011-06-02 14:12:40 |
Message-ID: | 4DE79A58.4010608@esilo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
On 6/2/2011 4:28 AM, Pavel Golub wrote:
> Hello, Andrew.
>
> You wrote:
>
> AC> On 6/1/2011 11:43 AM, Pavel Golub wrote:
>>> Hello.
>>>
>>> I'm some kind of PQdeleteTuple function will be very usefull in libpq.
>>> Because right now after deleting some record I need refetch result
>>> set, or mark tuple as deleted and this is headache for me.
>>>
>
> AC> IMHO, this should be handled by the application. You could track tuples
> AC> removed in an int[] or copy the result set into an application defined
> AC> array of C structures. I've always been under the impression that
> AC> PGresult objects are immutable once delivered to the application.
>
>
> Andrew, why we have PQmakeEmptyPGresult, PQcopyResult,
> PQsetResultAttrs, PQsetvalue and PQresultAlloc in this case? Of course
> there's no big deal with their absence but let's be consistent.
>
I'm not entirely sure what you are trying to do, but can't you use
PQmakeEmptyPGresult, PQsetResultAttrs and PQsetvalue to construct a
result that excludes the tuples you don't want followed by a
PQclear(initial_result)?
--
Andrew Chernow
eSilo, LLC
global backup
http://www.esilo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-06-02 14:28:27 | Re: pgpool versus sequences |
Previous Message | Alexey Klyukin | 2011-06-02 14:08:51 | Re: Identifying no-op length coercions |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Golub | 2011-06-02 14:32:15 | Re: [HACKERS] PQdeleteTuple function in libpq |
Previous Message | Merlin Moncure | 2011-06-02 13:30:49 | Re: PQdeleteTuple function in libpq |