Postgres Pro
Downloads
Home   >   mailing lists

Re: is there any difference DROP PRIMARY KEY in oracle and postgres? - Mailing list pgsql-general

From Tom Lane
Subject Re: is there any difference DROP PRIMARY KEY in oracle and postgres?
Date
Msg-id 18059.1446823494@sss.pgh.pa.us
Whole thread Raw
In response to Re: is there any difference DROP PRIMARY KEY in oracle and postgres?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
John R Pierce <pierce@hogranch.com> writes:
> On 11/5/2015 11:25 PM, Thomas Kellerer wrote:
>> But having an "alter table drop primary key" would indeed be nice.

> is that syntax in the sql standard?   or is it just an oraclism?

AFAICS there is no such syntax in SQL:2011 --- it only offers
"ALTER TABLE name DROP CONSTRAINT name".

            regards, tom lane

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: "Web of trust" connections
Next
From: Bertrand Roos
Date:
Subject: Re: Auto-analyse on insert operations