Retrieving variable names from ids in pl_exec.c

Started by Dimitris Karampinasalmost 15 years ago2 messageshackers
Jump to latest
#1Dimitris Karampinas
dkarampin@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dimitris Karampinas (#1)
Re: Retrieving variable names from ids in pl_exec.c

Dimitris Karampinas <dkarampin@gmail.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