PRIMARY KEY constraint questions.

From: Viacheslav N Tararin <taras(at)deka(dot)kp(dot)km(dot)ua>
To: pgsql-general <postgresql(dot)org!pgsql-general(at)deka(dot)kp(dot)km(dot)ua>
Subject: PRIMARY KEY constraint questions.
Date: 2001-04-28 06:07:03
Message-ID: 1131401925.20010428090703@deka.kp.km.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi ,

I try to move my old SQLAnywhere database to PostgreSQL 7.1 and found
some problem.

I can't perform next DDL:

ALTER TABLE xxx ADD PRIMARY KEY ( a, b );

And some questions:
1. Does anybody know what type of indext create PRIMARY KEY constraint
and how I can change this type?
2. How I can create primary key constraint without index?

Thanks.
--
Best regards,
Viacheslav mailto:taras(at)deka(dot)kp(dot)km(dot)ua

Browse pgsql-general by date

  From Date Subject
Next Message prabakaran 2001-04-28 08:07:58
Previous Message Anzo 2001-04-28 04:22:11 Re: how to migrate from SQL Server7 to PostgreSQL7??