sending row data to frontend - reg

From: "Rose Catherine K" <rosecatherinek(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: sending row data to frontend - reg
Date: 2007-11-05 18:52:02
Message-ID: 434a55ca0711051052y6b2d9942odff6548c27197433@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

we are trying to modify the source code of postgresql to support a new
command pivot <colA> <colB> <tablename>
we are doing the following steps:
1. After parsing the input, we are able to get the values entered by the
user for column A , column B and tablename.
2. Then, from postgresmain, we call exec_simple_query with a new query
"select * from tablename"
3. Then we read the result of execution of this query from
sendrowdescriptionmessage and printtup functions and also, don't allow these
to send the result of the select query to the frontend
4. now, we do the required changes needed for the pivot command
5. after this, from executorrun, we call sendrowdescriptionmessage function
( with modifications) to send the newly calculated row description - this is
working fine
6. Now, we want to send the newly calculated row data to the frontend. We
are not able to do this...
is there any way to send the row values, without invoking the executeplan
again? - since executeplan is overwriting the earlier sent rowdescription
(which we are not able to figure out why ! )

Can anyone help us?
we would be grateful, if you could give any pointers in this regard.

Thanking you in advance,
Rose.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-11-05 18:57:39 Re: Open items for 8.3
Previous Message Alvaro Herrera 2007-11-05 18:31:39 Re: pg 8.3beta 2 restore db with autovacuum report