Re: is there any difference DROP PRIMARY KEY in oracle and postgres?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is there any difference DROP PRIMARY KEY in oracle and postgres?
Date: 2015-11-06 15:24:54
Message-ID: 18059.1446823494@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John R Pierce <pierce(at)hogranch(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bertrand Roos 2015-11-06 17:13:42 Re: Auto-analyse on insert operations
Previous Message Mark Morgan Lloyd 2015-11-06 14:01:34 "Web of trust" connections