If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: SQL Logging

Hello Everyone,

Just started to put together a PostgreSQL environment after a client switch from MySQL. Anyway, this client is pretty saavy so I trust them, but they recently claimed that a column disappeared on them. My questions are...

1.) Has anyone heard of this happening (e.g. bug)?
2.) Is there anyway to "log" all SQL commands in order to track things like this when they happen?

Secondary question...

3.) Does anyone here use phpPgAmdin? I find it useful, but the user administration is a bit quirky? How come an un priviledged user can see all DBs, tables, et. al?

Thanks very much in advance!!!!! I look forward to the headaches and learning PostgreSQL.