Is it possible to drop primary key constraint on a table without dropping the index? I have a situation when I want to remove the
PRIMARY KEY to get rid of the
NOT NULL constraints and set it to another column pair. I want to avoid dropping and recreating the index. Can just the
PRIMARY KEY 'attribute' on the index be dropped? Dropping the constraint removes the index.
I am using PostgreSQL version 9.1.