x asasaxax wrote:
Hi, 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, a serial type will always be unique.
If not, what can i do to make this happen?
Re-evaluate your schema. Why do you want these two columns to have such a relationship? If it's very important, don't use a serial for cod and have your application figure out the value to assign.
b -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
