| Lists: | pgsql-hackers |
|---|
| From: | Dimitris Karampinas <dkarampin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Retrieving variable names from ids in pl_exec.c |
| Date: | 2011-05-31 21:34:02 |
| Message-ID: | 4DE55ECA.2070002@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hello,
Is there any way to retrieve the actual variable names (as were given
during Stored Procedure definition) for the corresponding var_ids in
pl/plpgsql/src/pl_exec.c ?
I have modified some PostgreSQL code for my own project and I track some
information for functions during their execution. It would be much more
clear at the end if I could map variable ids to their actual names.
Thanks in advance
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dimitris Karampinas <dkarampin(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Retrieving variable names from ids in pl_exec.c |
| Date: | 2011-05-31 22:14:58 |
| Message-ID: | 2867.1306880098@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Dimitris Karampinas <dkarampin(at)gmail(dot)com> writes:
> Is there any way to retrieve the actual variable names (as were given
> during Stored Procedure definition) for the corresponding var_ids in
> pl/plpgsql/src/pl_exec.c ?
As of 9.0, you could dig through the namespace stack looking for a
match to the dno (datum number). In earlier releases, no chance because
that data structure wasn't kept around after compile.
regards, tom lane