The following issue has been SUBMITTED.
==
http://www.dbmail.org/mantis/view.php?id=281
==
Reported By:kouta
Assigned To:
On Sun, 2005-11-06 at 14:28 -0800, K C wrote:
> I've replaced this kind of unique indexes with just normal
> (physmessage_id) if there is no other index can index physmessage_id.
> This is to make sure physmessage_id can use index. But unique index
> on (physmessage_id, id) is unnecessary here.
P
If you're talking about mysql I won't argue as I know nothing about it. But
for pgsql, the primary key index can't be dropped:
test=> drop INDEX tt_pkey ;
ERROR: cannot drop index tt_pkey because constraint tt_pkey on table tt
requires it
HINT: You may drop constraint tt_pkey on table tt instead.
On Mon, 2005-11-07 at 09:53 -0800, K C wrote:
> If you're talking about mysql I won't argue as I know nothing about
> it. But for pgsql, the primary key index can't be dropped:
>
> test=> drop INDEX tt_pkey ;
> ERROR: cannot drop index tt_pkey because constraint tt_pkey on table
> tt requires it