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@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 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
