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.
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 |