From: Jan Wieck <JanWieck@Yahoo.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Iavor Raytchev <iavor.raytchev@verysmall.org>
Cc: Hannu Krosing <hannu@tm.ee>
Cc: PostgreSQL HACKERS <pgsql-hackers@postgresql.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [HACKERS] bugzilla.pgaccess.org
Date: Thu, 11 Jul 2002 22:46:47 -0400
Message-ID: <3D2E4317.B9827615@Yahoo.com> (raw)
References: <GNELIHDDFBOCMGBFGEFOOEBICDAA.chriskl@familyhealth.com.au>
Christopher Kings-Lynne wrote:
>
> > The Bugzilla project plans to support PostgreSQL in one of their future
> > releases, but this requires functionality in PostgreSQL, that is not
> > even scheduled for 7.3. So the availability of a supported PostgreSQL
> > port of Bugzilla is unpredictable at this time.
>
> I think he said that they needed DROP COLUMN functionality, which is being
> worked on for 7.3. (Although I haven't had time to work on it for a few
> days)
DROP COLUMN is the one we might solve in 7.3. ALTER COLUMN ...
TYPE was mentioned too and I don't know when or how we will have
that one.
REPLACE INTO is one more. Though you can work around it. If you
setup a BEFORE INSERT trigger, in which you do a table lock, then
try to UPDATE an existing row with NEW's key. If that succeeds,
you return NULL, suppressing the INSERT. If it fails, you return
NEW letting the INSERT happen. The table lock (what Bradley
called "heavy locking") is required because otherwise someone can
sneak in between your update attempt and letting the INSERT
happen, getting exactly the same result and ... boom, duplicate
key error.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me. #
#==================================================
JanWieck@Yahoo.com #
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-interfaces@postgresql.org
Cc: JanWieck@Yahoo.com, chriskl@familyhealth.com.au, iavor.raytchev@verysmall.org, hannu@tm.ee, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] bugzilla.pgaccess.org
In-Reply-To: <3D2E4317.B9827615@Yahoo.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