Re: pk vs unique not null differences between 8.3.4 and 8.3.8

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pk vs unique not null differences between 8.3.4 and 8.3.8
Date: 2009-11-02 14:53:06
Message-ID: 24514.1257173586@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> This statement succede in 8.3.8
> alter table shop_commerce_gift drop constraint
> shop_commerce_gift_pkey;
> but failed in 8.3.4.

Uh, that doesn't seem to match the name of the index?

> Indexes:
> "shop_commerce_gift_giftcode_key" UNIQUE, btree (giftcode)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-11-02 14:55:20 Re: array_reverse()
Previous Message Sam Mason 2009-11-02 14:51:59 Re: array_reverse()