From: John <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org
Subject: Re: strangest thing happened
Date: Wed, 7 Jul 2010 15:41:27 -0700
Message-ID: <201007071541.27248.johnf@jfcomputer.com> (raw)
In-Reply-To: <4C34FC50.6070203@magwerks.com>
References: <201007071259.03294.johnf@jfcomputer.com>
<20100707204244.GB28181@rice.edu>
<4C34FC50.6070203@magwerks.com>
On Wednesday 07 July 2010 03:14:40 pm Justin Graf wrote:
> I would be looking at the log files for the Inserts into that table as a
> means to track down what is the cause. If there are no log files or
> don't have enough detail, crank up the logging level and wait for it to
> happen again???
That is scary - let it happen again???? I'm not keeping enough info in the
log. I actually turned off most of the info the log files are gathering
because the system has been running for 6-7 months without an issue. I just
got a call around noon telling me something was going wrong. That's when I
discovered the sequences were the wrong values. I'm sure there has to be
some sort of real explanation - but I don't know what it is.
Johnf
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: johnf@jfcomputer.com
Subject: Re: strangest thing happened
In-Reply-To: <201007071541.27248.johnf@jfcomputer.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox