Richard Huxton wrote: >> What'd be the syntax to create a primary key on an already >> build table? > > ALTER TABLE my_table ADD PRIMARY CONSTRAINT (existing_column);
I'm sure it's just a typo, but that is wrong. It is not ADD PRIMARY CONSTRAINT, but ADD PRIMARY KEY. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
