Re: UPDATE slow

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: John Smith <john_smith_45678(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: UPDATE slow
Date: 2003-02-04 22:54:54
Message-ID: 20030204144950.G10681-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Smith 2003-02-04 22:57:05 Re: UPDATE slow [Viruschecked]
Previous Message Patric Bechtel 2003-02-04 22:52:12 Re: UPDATE slow [Viruschecked]