Re: Primary Key with serial

can anyone do a example for me.. an explain how it works?

Thanks a lot

2008/3/29, Berend Tober <btober(at)ct(dot)metrocast(dot)net>:
>
> 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
>
>
>