Hi,
I have seen in the documentation an example of adding a trigger to a
sequence, so no duplicates will be inserted when using the sequence.
Problem is, I can't find it anymore. Can anyone hint me, where it is?
Heiko
And below is the long description:
I have the following table:
create table test (id serial, text char(5));
as long as I don't insert a id manually, everything works fine.
(insert into test (text) VALUES '1';)
...
id | text
----+-------
1 | 1
2 | 2
3 | 3
when I insert the id manually:
insert into test (id, text) VALUES (5,'4');
I get what I expect:
id | text
----+-------
1 | 1
2 | 2
3 | 3
5 | 4
But inserting two more rows:
insert into test (text) VALUES ('5');
id | text
----+-------
1 | 1
2 | 2
3 | 3
5 | 4
4 | 5
insert into test (text) VALUES ('6');
ERROR: Cannot insert a duplicate key into unique index test_id_key
I understand, the sequence will give me 5 as id and that's already
there. I would like the table to look like this:
id | text
----+-------
1 | 1
2 | 2
3 | 3
5 | 4 --- here I inserted id manually
6 | 5
7 | 6
How do I solve this?
Heiok