On 04/19/2012 07:19 AM, Yvon Thoraval wrote:
i do have a serial named 'rowid' it is of "SERIAL PRIMARY KEY" in a table 'items'.if i delete some of the rows i can't anymore insert afterwards. even if i rearrange de sequence by : "SELECT MAX(rowid) FROM items;"; "SELECT last_value FROM items_rowid_seq;"; then if last_value is lower than MAX(rowid) i set it to MAX(rowid) : "SELECT setval('items_rowid_seq', max(rowid)) FROM items;"; and even after that i get an error when inserting by : "INSERT ... RETURNING rowid;" here I'm not only unable to read back the rowid but also inserion failed.
What does the error say?
why ? -- Yvon
-- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
