On Wed, Apr 2, 2008 at 11:21 AM, beamends <
..hidden..> wrote:
Hi all,
sorry to a nuisance, but....
When adding a vendor (the first one) I get
DBD::Pg::db do failed: ERROR: duplicate key violates unique constraint
"transactions_pkey"
Error!
INSERT INTO vendor (name)
VALUES ('Wed Apr 2 19:15:52 200816161')
ERROR: duplicate key violates unique constraint "transactions_pkey"
In psql, run:
SELECT setval('id', select max(id) from transactions);
any ideas. Also, I'm probably being a bit thick, but what does the
"200816161" bit represent?
2008 is the year, 16161 is the process id.
We are fixing that sort of thing, BTW :-)
Best Wishes
Chris Travers