sending row data to frontend - reg - Mailing list pgsql-hackers

From Rose Catherine K
Subject sending row data to frontend - reg
Date
Msg-id 434a55ca0711051052y6b2d9942odff6548c27197433@mail.gmail.com
Whole thread Raw
Responses Re: sending row data to frontend - reg  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi All,<br /><br />we are trying to modify the source code of postgresql to support a new command pivot <colA>
<colB><tablename><br />we are doing the following steps:<br />1. After parsing the input, we are able to
getthe values entered by the user for column A , column B and tablename. <br />2. Then, from postgresmain, we call
exec_simple_querywith a new query "select * from tablename"<br />3. Then we read the result of execution of this query
fromsendrowdescriptionmessage and printtup functions and also, don't allow these to send the result of the select query
tothe frontend <br />4. now, we do the required changes needed for the pivot command <br />5. after this, from
executorrun, we call sendrowdescriptionmessage function ( with modifications) to send the newly calculated row
description- this is working fine <br />6. Now, we want to send the newly calculated row data to the frontend. We are
notable to do this...<br />is there any way to send the row values, without invoking the executeplan again? - since
executeplanis overwriting the earlier sent rowdescription (which we are not able to figure out why ! ) <br /><br />Can
anyonehelp us? <br />we would be grateful, if you could give any pointers in this regard.<br /><br />Thanking you in
advance,<br/>Rose.<br /><br /> 

pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Open items for 8.3
Next
From: Alvaro Herrera
Date:
Subject: Re: pg 8.3beta 2 restore db with autovacuum report