From waheed@digiba.com Thu Dec  12 06:11:57 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2B5FF4762AA
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 01:11:57 -0500 (EST)
Received: from digiba.com (digiba.com [213.132.36.35])
	by postgresql.org (Postfix) with ESMTP id 09779475F3D
	for <pgsql-sql@postgresql.org>; Thu, 12 Dec 2002 01:11:55 -0500 (EST)
Received: from yellow [213.132.62.253] by digiba.com with ESMTP
	(SMTPD32-7.07) id A92F3E0278; Thu, 12 Dec 2002 10:14:07 +0400
Message-ID: <004601c26c2e$ba5c9400$0305a8c0@yellow>
From: "Waheed Rahuman" <waheed@digiba.com>
To: "Great ! PostGreSQL----> Help" <pgsql-sql@postgresql.org>
Subject: Primary Key Help !
Date: Fri, 4 Oct 2002 22:19:06 -0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0043_01C26BF4.0DE85F40"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/143
X-Sequence-Number: 10731

This is a multi-part message in MIME format.

------=_NextPart_000_0043_01C26BF4.0DE85F40
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Greetings
Friends please help me in setting the primary key
in a table how many primary key i can create.
In MS access its only 10 column can be made into primary key !.
My question is How many primary key i can assign in a PostGresql Table

Rowid        |      Parent1       |      Parent2       |      Parent3      =
 |      Parent4       |      Parent5       |      Parent6       |      Pare=
nt7       |      Parent8       |      Parent9       |      Parent10      |

Here i want to make Parent1.........Parent 10 as Primary Key  and ...this p=
arent field i want to make it more than 10 fields....if i try to make prima=
ry 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 wi=
ll be glad
Thank you for your reply
Regards
Waheed





------=_NextPart_000_0043_01C26BF4.0DE85F40
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Greetings</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Friends please help me in setting the prim=
ary=20
key</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>in a table how many primary key i can=20
create.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>In MS access its only 10 column can be mad=
e into=20
primary key !.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>My question is How many primary key i can =
assign in=20
a PostGresql Table</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Rowid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
|<BR></FONT><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Here i want to make Parent1.........Parent=
 10=20
as&nbsp;Primary Key &nbsp;and ...this parent field i want to make it more t=
han=20
10 fields....if i try to make primary key more than 10 fields in ms access =
its=20
say not possible so please let me know how i can do that in psql. or if the=
re is=20
an alternative way...i will be glad</DIV>
<DIV>Thank you for your reply</DIV>
<DIV>Regards</DIV>
<DIV>Waheed</DIV>
<DIV>&nbsp;</DIV>
<DIV></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0043_01C26BF4.0DE85F40--




From lud_nowhere_man@yahoo.com Thu Dec  12 08:04:17 2002
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