X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87FD7D1B1EC for ; Mon, 2 Aug 2004 15:33:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55287-02 for ; Mon, 2 Aug 2004 18:33:02 +0000 (GMT) Received: from cms.mail.virginia.edu (fork2.mail.Virginia.EDU [128.143.2.192]) by svr1.postgresql.org (Postfix) with ESMTP id 4FA62D1B1DF for ; Mon, 2 Aug 2004 15:32:58 -0300 (ADT) Received: from virginia.edu (d-137-133-131.bootp.Virginia.EDU [137.54.133.131]) by cms.mail.virginia.edu (Postfix) with ESMTP id B39FA1680F0 for ; Mon, 2 Aug 2004 14:32:57 -0400 (EDT) Message-ID: <410E88D6.8050906@virginia.edu> Date: Mon, 02 Aug 2004 14:32:54 -0400 From: Jodi Kanter User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres Admin List Subject: no dup rows Content-Type: multipart/alternative; boundary="------------060001020709010703090909" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: * X-Archive-Number: 200408/9 X-Sequence-Number: 14404 This is a multi-part message in MIME format. --------------060001020709010703090909 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit I have a linking table that has only two fields in it and both are foreign keys to other tables. I'd like to ensure that there are never any duplicate rows in this table. I was planning on creating a multi-column unique index to satisfy this requirement. Is there a more appropriate way to accomplish this or am I on the right track?> thanks. Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu --------------060001020709010703090909 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit I have a linking table that has only two fields in it and both are foreign keys to other tables. I'd like to ensure that there are never any duplicate rows in this table. I was planning on creating a multi-column unique index to satisfy this requirement. Is there a more appropriate way to accomplish this or am I on the right track?>
thanks.
Jodi
--
_______________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

--------------060001020709010703090909--