| 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:58:48 |
| Message-ID: | 20030204145657.D10833-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Harr | 2003-02-04 23:03:08 | Re: What is the safest way to get last insert ID of a serial column ? |
| Previous Message | John Smith | 2003-02-04 22:57:05 | Re: UPDATE slow [Viruschecked] |