Results 1 to 3 of 3

Thread: SQL Logging

  1. #1
    Join Date
    Aug 2003
    Location
    Reston, VA
    Posts
    59

    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.

    Best,
    DrS

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    logging

    logging

    look in the postgresql.conf file

    log_statement = true

    never heard of a bug like that
    maybe someone is experiencing with alter table drop column
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Aug 2003
    Location
    Reston, VA
    Posts
    59

    Thanks..

    Simple question, simple answer. Surprised I overlooked this one....

    Yes, I'm thinking it was an Alter Command issue that someone did by mistake, hence the logging from now on. I don't think it was me, so here's the proof!!!

    Thanks,
    DrS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •