From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: is there any difference DROP PRIMARY KEY in oracle and postgres? |
Date: | 2015-11-06 04:03:08 |
Message-ID: | 563C267C.3050406@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/05/2015 07:52 PM, M Tarkeshwar Rao wrote:
> Hi,
>
> one thing in oracle is there any difference between “DROP PRIMARY KEY”
> used directly in oracle to drop primary key, or “DROP CONSTRAINT
> CDRAUDITPOINT_pk”, as first syntax is not available in postgres and we
> need to give primary key name as constraint to delete a key. SO right
> now to delete primary key I am using second approach, so is there any
> difference between two?
No. As a PRIMARY KEY is technically a constraint, we use ALTER TABLE
DROP CONSTRAINT.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
New rule for social situations: "If you think to yourself not even
JD would say this..." Stop and shut your mouth. It's going to be bad.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2015-11-06 06:06:06 | Re: Lock contention in TransactionIdIsInProgress() |
Previous Message | Melvin Davidson | 2015-11-06 04:00:18 | Re: is there any difference DROP PRIMARY KEY in oracle and postgres? |