On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote:
>> Could ALTER TABLE use an option to drop the
>> primary key constraint? I needed to do that,
>> found it was not obvious, and this lead me to
>> try to improve things.
>
> That could be useful, I think. But it might open a can of worms.
Would the new option be syntactic sugar around ALTER TABLE ... DROP
CONSTRAINT "put_the_name_of_the_primary_key_here"?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company