Re: [GENERAL] drop key translation

2009-08-14 Thread Chris
Skylar Saveland wrote: alter table profile_projectexp drop key profile_projectexp_person_id_6fe12f6f; I think that this syntax is specific to mysql. can someone translate? drop index profile_projectexp_person_id_6fe12f6f; -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent v

Re: [GENERAL] drop key translation

2009-08-14 Thread A. Kretschmer
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 ; For

[GENERAL] drop key translation

2009-08-14 Thread 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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgs