On Mon, 02 Nov 2009 09:53:06 -0500 Tom Lane <t...@sss.pgh.pa.us> wrote:
> Ivan Sergio Borgonovo <m...@webthatworks.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? Yep... that was my surprise. I don't have a time machine to be absolutely sure about what I did but I should have created a pk on both machines with a create table shop_commerce_gift( giftcode varchar primary key ... ); but in the newer pg I actually find the pk constraint... in the older I find a not null + an unique index with a different name from the pk name of the former. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
