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

2009-11-02 Thread Ivan Sergio Borgonovo
On Mon, 02 Nov 2009 09:53:06 -0500 Tom Lane wrote: > Ivan Sergio Borgonovo 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? Yep... that

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

2009-11-02 Thread Tom Lane
Ivan Sergio Borgonovo 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)

[GENERAL] pk vs unique not null differences between 8.3.4 and 8.3.8

2009-11-02 Thread Ivan Sergio Borgonovo
I prepared a script to upgrade the schema in a 8.3.8 dev box and now I was trying to replicate the change in a staging 8.3.4 box... and it failed. I don't have a recent backup of my dev box so I can't check if I'm day dreaming. This statement succede in 8.3.8 alter table shop_commerce_gift drop c