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@xxxxxxxxxxxxx> wrote:
PFC <lists@xxxxxxxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
