On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut <pete...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers