Re: drop key translation

In response to Skylar Saveland :
> alter table profile_projectexp drop key
> profile_projectexp_person_id_6fe12f6f;
>
> I think that this syntax is specific to mysql. can someone translate?

What do you want to achieve? DROP the Primary Key?

ALTER TABLE profile_projectexp DROP CONSTRAINT <constraint_name>;

For instance:

test=# create table foo (id int primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo"
CREATE TABLE
test=*# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
id | integer | not null
Indexes:
"foo_pkey" PRIMARY KEY, btree (id)

test=*# alter table foo drop constraint foo_pkey;
ALTER TABLE

HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net