Re: UPDATE slow - Mailing list pgsql-general

From Stephan Szabo
Subject Re: UPDATE slow
Date
Msg-id 20030204145657.D10833-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: UPDATE slow  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: UPDATE slow
List pgsql-general
On Tue, 4 Feb 2003, Stephan Szabo wrote:

>
> On Tue, 4 Feb 2003, John Smith wrote:
>
> > I should also probably note that neither of the foreign key columns is being updated.
>
> It doesn't matter, unfortunately. It currently checks even in that case
> due to ON * SET DEFAULT having a failure case if you don't check when no
> keys are changed (if you remove the default - and you can't necessarily
> check this beforehand either if the defaults are not stable).  Among the
> various changes I've been working with is making it only do the check if
> one of the set default cases is given or if the key changed.

I've actually got most of that done as part of the other patches I've been
working on.  I could probably try to do the same to 7.3 (as opposed to
7.4 devel) and make a separate patch out of it.


pgsql-general by date:

Previous
From: John Smith
Date:
Subject: Re: UPDATE slow [Viruschecked]
Next
From: Lee Harr
Date:
Subject: Re: What is the safest way to get last insert ID of a serial column ?