From: Laurette Cisneros <laurette@nextbus.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: foreign key problem
Date: Wed, 9 Oct 2002 16:16:23 -0700 (PDT)
Message-ID: <Pine.LNX.4.44.0210091613590.2174-100000@visor.corp.nextbus.com> (raw)
In-Reply-To: <200210061711.46128.josh@agliodbs.com>
7.2.3.
It's a mystery as to how this happened but there is a program we use to
copy rows from one version to another. For some reason the person who
wrote it disabled triggers before copying rows to a new version then
re-enabled the triggers. If someone made changes while the triggers were
off then this could happen. At least that's my story and I'm sticking to
it.
So, the program has been fixed and we hope this plugs the hole that that
rabbit went down.
Thanks,
L.
On Sun, 6 Oct 2002, Josh Berkus wrote:
> Laurette,
>
> > How is this possible? I've tried to reproduce this, but haven't been able
> > to yet. This has happened to use several times.
>
> Oh, forgot question 2:
> SELECT version()?
>
>
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
------------------------------
It's 10 o'clock...
Do you know where your bus is?
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: laurette@nextbus.com, josh@agliodbs.com
Subject: Re: foreign key problem
In-Reply-To: <Pine.LNX.4.44.0210091613590.2174-100000@visor.corp.nextbus.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