Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id F0130476138
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 03:04:17 -0500 (EST)
Received: from web80306.mail.yahoo.com (web80306.mail.yahoo.com
 [66.218.79.22])
	by postgresql.org (Postfix) with SMTP id DE52D476061
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 03:04:16 -0500 (EST)
Message-ID: <20021212080417.56978.qmail@web80306.mail.yahoo.com>
Received: from [203.87.150.116] by web80306.mail.yahoo.com via HTTP;
	Thu, 12 Dec 2002 00:04:17 PST
Date: Thu, 12 Dec 2002 00:04:17 -0800 (PST)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: Re: Primary Key Help !
To: Waheed Rahuman <waheed@digiba.com>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
In-Reply-To: <004601c26c2e$ba5c9400$0305a8c0@yellow>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/145
X-Sequence-Number: 10733


--- Waheed Rahuman <waheed@digiba.com> wrote:
> Hi Greetings
> My question is How many primary key i can assign in
> a PostGresql Table
> 
> Rowid        |      Parent1       |      Parent2    
>   |      Parent3       |      Parent4       |     
> Parent5       |      Parent6       |      Parent7   
>    |      Parent8       |      Parent9       |     
> Parent10      |
> 
> Here i want to make Parent1.........Parent 10 as
> Primary Key  and ...this parent field i want to make
> it more than 10 fields....if i try to make primary
> key more than 10 fields in ms access its say not
> possible so please let me know how i can do that in
> psql. or if there is an alternative way...i will be
> glad

  Assuming that you have already created the table try
doing the following:

   ALTER TABLE <table> ADD CONSTRAINT <constraint
name> PRIMARY KEY (parent1,parent2....,parent10);

Hope that helps,

ludwig


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com