Re: Problem with database: FATAL 1: cannot find attribute 24 - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with database: FATAL 1: cannot find attribute 24
Date
Msg-id 25148.1000835980@sss.pgh.pa.us
Whole thread Raw
List pgsql-general
"Tauren Mills" <tauren@servlets.net> writes:
> Thanks for the help!  I'm afraid I do not know how to do this.  Is there
> somewhere that specifically explains how to run a standalone backend under
> gdb?  How would I set a breakpoint at elog or get a stack trace?

You should look at the gdb documentation, but running a standalone
backend under gdb isn't hard:

    gdb path-to-postgres-executable

    gdb> break elog
    gdb> run command-line-arguments-for-standalone-backend
    ...
    ... break at elog
    ...
    gdb> bt        (backtrace)
    gdb> cont    (continue till next breakpoint)

    gdb> quit    (when done)

> Does the RPM version of Postgres include debugging symbols,

Not sure, but I doubt it.  If you don't see a symbolic backtrace
including routine names and argument values, then you haven't got
debugging symbols.  In particular, if you can't see the string
being passed to elog then you'll have trouble telling which breakpoint
stop is the interesting one ...

            regards, tom lane

pgsql-general by date:

Previous
From: Cosmos Tong
Date:
Subject: Error in compiling PHP with PostgreSQL support
Next
From: "Corn"
Date:
Subject: Re: Some Japanies charaters cannot be seen when using JDBC driver