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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
