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: > >   gms=> \d jobclock >                 >                 >      

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
Just create a unique constraint on all of the columns. Matthew Hartman Programmer/Analyst Information Management, ICP Kingston General Hospital (613) 549- x4294 > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf