Re: failed insert into serial-type row

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> and sometimes if i'm adding new rows to the table with statements like
> this:
> insert into (name,value) ('xy','xy');

Show us the actual SQL, not something "like" it. The above is not valid.

> CREATE SEQUENCE session.preferences_id_seq
> START 2487

You haven't shown us how this sequence is attached to the table. Presumably
with:

ALTER TABLE preferences ALTER id SET DEFAULT nextval('preferences_id_seq');

That START qualifier is a red flag. If the sequence was not created when the table
was, one explanation is that there are existing values in the table that are higher
than the current sequence. Running
SELECT max(id) FROM preferences
and
SELECT * FROM preferences_id_seq;
should show that. The other possibility is that someone is inserting into the table
and specifying a value for the id field manually.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200506180957
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCtCoLvJuQZxSWSsgRAkiVAKDG6eVWdCdqzbnQnqIOHyoZ/ijzOACfcgh+
9P9fUQbyJUXebzHvOf4F3Z8=
=QKrK
-----END PGP SIGNATURE-----