Re: Primary Key with serial

From: Berend Tober <btober(at)ct(dot)metrocast(dot)net>
To: x asasaxax <xanaruto(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Primary Key with serial
Date: 2008-03-29 16:54:06
Message-ID: 47EE742E.3040901@ct.metrocast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

x asasaxax wrote:
> I have the following table create table product(cod serial, user_cod
> bigint, constraint product_fk Foreign Key(user_cod) references user(cod),
> constraint product_pk Primary Key(cod, user_cod));
>
> What i want to happend is that:
> user_cod cod
> 1 1
> 1 2
> 1 3
> 2 1
> 3 1
> 3 2
>
> Can serial do that? ...

No.

> ...what can i do to make this happen?

http://archives.postgresql.org/pgsql-general/2006-08/msg00744.php

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-03-29 16:55:09 Re: Using tables in other PostGreSQL database
Previous Message Shane Ambler 2008-03-29 16:36:05 Re: GSoC Proposal: PL/Mono