Re: BUG #2481: select from table's join with geometries doesn't go

Emilia Venturato <venturato@faunalia.it> writes:
> Alle 16:18, venerdì 16 giugno 2006, Tom Lane ha probabilmente scritto:
>> Emilia might have found some corner case where it doesn't, though;
>> perhaps a malloc call that's not error-checked.  A stack trace from
>> the psql core dump would be useful.

> Core dump is not generated.
> How can I generate a back-trace?

You probably need to adjust your "ulimit -c" setting to get a core dump
to be generated.  Alternatively and maybe faster, just run psql under
gdb to start with:

    $ gdb /path/to/psql
    gdb> run arguments-for-psql-go-here
    ... interact with psql normally, provoke crash
    gdb will report SIGSEGV and give you a prompt:
    gdb> bt
    ... stack trace printed here ...
    gdb> quit
    $

If the stack trace contains only numeric addresses then it won't be any
help; in that case please recompile psql with debugging support so you
can get a useful trace.

            regards, tom lane