pgadmin3 does this (from pg's log with level set at debug5):
INSTRUCTION : SELECT db.oid, datname, datpath, datallowconn, datconfig,
datacl, pg_encoding_to_char(encoding) AS serverencoding,
pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid,
'CREATE') as cancreate
FROM pg_database db
ORDER BY datname
ERREUR: 42703: la colonne <<datpath>> n'existe pas
EMPLACEMENT : transformColumnRef, parse_expr.c:1099
Do you know if this is normal, should this column exist, is it a problem
with pgadmin ?
Thanks !
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
>