Re: Primary Key with serial the solution?

How about if i do this inside a procedure:

SELECT setval('sequence',(SELECT max(id) FROM table)) INTO variable;
insert into table values(variable, ..., ...); ?

Will this be transactional? Cause, they say that setval is a command
that its transactional. Using this way i
don´t will need to use a sequence anymore. Is that correct?

Thanks you all.

2008/3/31, x asasaxax <xanaruto(at)gmail(dot)com>:
>
> 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
> >
> >
> >
>