Re: Multicolumn foreign keys need useless unique indices?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Antti Haapala <antti(dot)haapala(at)iki(dot)fi>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Multicolumn foreign keys need useless unique indices?
Date: 2002-09-13 15:42:21
Message-ID: 1031931742.16745.14.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> hannu=# update t set i=i+1;
> ERROR: Cannot insert a duplicate key into unique index t_i_key

A possibility may be to reverse the sequential scan order for the simple
cases, but anything any more complex and the check should be deferred
till end of statement, rather than checking immediately.

--
Rod Taylor

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-09-13 16:31:29 Re: Multicolumn foreign keys need useless unique indices?
Previous Message Jan Wieck 2002-09-13 15:26:40 Re: TOAST docs