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@gmail.com>:can anyone do a example for me.. an explain how it works?
Thanks a lot
2008/3/29, Berend Tober <btober@ct.metrocast.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