Sometimes life has an irony of itself.
Today I modified some of my gentoo USE flags for something totally
unrelated to postgres.
Tonight I built postgres in debug mode : the offending query worked.
I thught "hm."
I rebuilt it without debug, and it still works.
I don't know what made it NOT to work before, I sure didn't hallucinate.
It must be some obscure incompatibility deep inside the Gentoo package and
build manager...
phppgadmin works, and pgadmin doesn't, telling me the "datapath" column
doesn't exist, no idea what this means. I'm going to look into it.
Thanks for your help and sorry about bothering you !
On Mon, 11 Apr 2005 18:42:29 +0200, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> PFC <lists@boutiquenumerique.com> writes:
>> I have no idea what to type in gbd to get the trace, though....
>
> What I usually do is
> - start a psql session
> - in another window, find out the PID of the backend attached
> to the psql session, and do
> $ gdb /path/to/postgres backend_PID
> ...
> gdb> b errfinish
> gdb> cont
> - go back to psql session and issue problem command
> - when gdb stops execution, do
> gdb> bt
> ... useful printout is here ...
> gdb> quit
> sure you want to exit? y
>
> regards, tom lane
>