Re: Changing the Primary Key Column

On Thu, 24 Feb 2011, Brent Dombrowski wrote:

> 'not null' is a column constraint, not the table constraint. Look for the
> table constraint at the bottom of the table description. It will likely be
> something like table_pkey. Here is a sample from a test database I have:

Brent,

Sonofagun! I totally missed this by being too close to the problem. Yes,
the table key was water_well_pkey.

Now that I dropped that key and the sequence_no column, what is the
correct syntax to add the primary key constraint to the now first column,
well_log? Trying to follow the 9.1 alter table page:

nevada-# alter table water_well add well_log_pkey
nevada-# commit;
ERROR: syntax error at or near "table"
LINE 2: alter table water_well add well_log_pkey
^
Thanks,

Rich