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

Поиск
Список
Период
Сортировка
От M Tarkeshwar Rao
Тема is there any difference DROP PRIMARY KEY in oracle and postgres?
Дата
Msg-id 1C16813DAFF3E44B939586605D40E9F024205B65@ESESSMB107.ericsson.se
обсуждение исходный текст
Ответы Re: is there any difference DROP PRIMARY KEY in oracle and postgres?  (Melvin Davidson <melvin6925@gmail.com>)
Re: is there any difference DROP PRIMARY KEY in oracle and postgres?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: is there any difference DROP PRIMARY KEY in oracle and postgres?  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general

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?

 

Regards

Tarkeshwar

 

В списке pgsql-general по дате отправления:

Предыдущее
От: bock@openit.de (Julian v. Bock)
Дата:
Сообщение: Lock contention in TransactionIdIsInProgress()
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: is there any difference DROP PRIMARY KEY in oracle and postgres?