Postgres Pro
Downloads
Home   >   mailing lists

no dup rows - Mailing list pgsql-admin

From Jodi Kanter
Subject no dup rows
Date
Msg-id 410E88D6.8050906@virginia.edu
Whole thread Raw
Responses Re: no dup rows  (Peter Eisentraut <peter_e@gmx.net>)
Re: no dup rows  (Bill Harper <bharper@solutionst.com>)
Re: no dup rows  (Reece Hart <reece@in-machina.com>)
List pgsql-admin
Tree view
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

 

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: running only pg_autovacuum for one week
Next
From: Peter Eisentraut
Date:
Subject: Re: no dup rows