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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
