Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6F3FD9FA625 for ; Wed, 19 Sep 2007 12:26:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 90664-05 for ; Wed, 19 Sep 2007 12:26:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31808.mail.mud.yahoo.com (web31808.mail.mud.yahoo.com [68.142.207.71]) by postgresql.org (Postfix) with SMTP id 417B09FA5F6 for ; Wed, 19 Sep 2007 12:26:16 -0300 (ADT) Received: (qmail 81540 invoked by uid 60001); 19 Sep 2007 15:26:15 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=kqCMoP3XjfP9P5MRAQeJpqeHTfNEYJmiKGdLS5P/dbs5ffEn+YjSSwJr7V90R8lxjm9rDrmM9eMjZbNlkJNUCHXLdLMA/tU6PlJcWFOMgqFssIEaNfHBXouaUvxUwFIxWD+S5Vzo5Ew/XG0sFcLd5gDtIiYPlRa0JOmduVYR6Ug=; X-YMail-OSG: z5Vt50wVM1nFvDRi6Db8kxE_psMW6Cg0iPcqbUBD00Ou4Qa.0SyBqKzh0enWZK67KZJG.YT5XnYrsWuuhk71e.lwppwmsXBMI4TrfCEIi1YH3ejeS3Dptv6AJjEC.A-- Received: from [12.180.237.138] by web31808.mail.mud.yahoo.com via HTTP; Wed, 19 Sep 2007 08:26:15 PDT Date: Wed, 19 Sep 2007 08:26:15 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Primary key To: Carol Walter , pgsql-admin@postgresql.org In-Reply-To: <94AE7849-041D-44EC-BF46-E8D13990CEE9@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <558465.79884.qm@web31808.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/110 X-Sequence-Number: 26871 --- Carol Walter wrote: > Does postgres allow compound or composite keys for primary keys? I > thought I read someplace that it didn't. Now, I can't find a > reference to it. It does. composite key are defined as a table constraint: http://www.postgresql.org/docs/8.2/interactive/sql-createtable.html This link illistrates syntax with this example: CREATE TABLE films ( code char(5), title varchar(40), did integer, date_prod date, kind varchar(10), len interval hour to minute, CONSTRAINT code_title PRIMARY KEY(code,title) ); Regards, Richard Broersma Jr.