Re: [GENERAL] simulate multiple primary keys

2009-07-02 Thread Lennin Caro
--- On Thu, 7/2/09, Brandon Metcalf wrote: > From: Brandon Metcalf > Subject: [GENERAL] simulate multiple primary keys > To: pgsql-general@postgresql.org > Date: Thursday, July 2, 2009, 5:27 PM > I have the following table: > >

Re: [GENERAL] simulate multiple primary keys

2009-07-02 Thread Bill Moran
In response to Brandon Metcalf : > I have the following table: > > gms=> \d jobclock > Table "public.jobclock" > Column| Type | > Modifiers > > -+--

Re: [GENERAL] simulate multiple primary keys

2009-07-02 Thread Brandon Metcalf
M == matthew.hart...@krcc.on.ca writes: M> Just create a unique constraint on all of the columns. Ah. Didn't realize you could specify more than one column as part of a unique constraint. Thanks. -- Brandon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] simulate multiple primary keys

2009-07-02 Thread Hartman, Matthew
l.org] On Behalf Of Brandon Metcalf > Sent: Thursday, July 02, 2009 1:28 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] simulate multiple primary keys > > I have the following table: > > gms=> \d jobclock > T

[GENERAL] simulate multiple primary keys

2009-07-02 Thread Brandon Metcalf
I have the following table: gms=> \d jobclock Table "public.jobclock" Column| Type | Modifiers -++---