Re: Primary Key

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Primary Key
Date: 2007-11-16 20:21:20
Message-ID: 20071116202120.GA1955@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 16, 2007 at 12:06:46PM -0800, Joshua D. Drake wrote:
> When that is needed I do this:
>
> create table foo(id serial unique, a text, b text, primary (a,b));

Humm, so the other way around from what I've ended up doing. I'll need
to think about the implications of changing things around like this.
There are lots of things that seems as though they'll be pretty awkard
to do, I'm sure it's just because I haven't thought about it enough.

Sam

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2007-11-16 20:24:21 Re: "field doesn't exist" even though I'm sure it does
Previous Message Joshua D. Drake 2007-11-16 20:20:37 Re: "field doesn't exist" even though I'm sure it does