Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Column Deletion


  • From: brian <brian(at)zijn-digital(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: Column Deletion
  • Date: Sun, 22 Oct 2006 19:01:02 -0400
  • Message-id: <453BF82E(dot)4050906(at)zijn-digital(dot)com>

Bob Pawley wrote:
I have a column of information that is being deleted after I have
initiated the run sequences on my host application. (The application
is in development.)

I have seen list messages about a PostgreSQL log that is available.
Can someone point me to documentation to access this log. It may give
me some clue as to where the problem originates?


It depends on how your logging is set up. Look in $PG_DATA/pg_log (where $PG_DATA is your postgres data dir). Or, they might be at /var/log/postgres (i'm assuming *NIX here).

Also, edit $PG_DATA/postgreql.conf and set log_statement to either "mod" or "all" (restart postgres afterwards).

brian



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group