SERIAL error
От | mstory@uchicago.edu |
---|---|
Тема | SERIAL error |
Дата | |
Msg-id | 1101617154.41a95802dbbeb@churlish.uchicago.edu обсуждение исходный текст |
Ответы |
Re: SERIAL error
Re: SERIAL error Re: SERIAL error Re: SERIAL error |
Список | pgsql-general |
I'm using v. 7.4.2, and am encountering a problem with serial types. On an insert into a table that results in failure for any number of reasone (mostly violation of contraints) I've found that the Sequence for the column of type serial will still bump the value up once. This can be seen when entering the next value with no problems, the value is 2 greater than the last value. Noticed this when experimenting with a serial column with a unique constriant, and then manually raising the serial value of a row to the next number due in the sequence, the first attempt caused an error, but on a second attempt it worked fine but the number was one higher than what i expected. It also occurs for errors pertaining to other columns, when using a two column table, one column with a not null constraint, and the other the serial column, entering in a null value for the first column causes the sequence to fire, and then following that with a valid entry you'll see the value for the serial column is +2 of the last value. This is still the case in a transaction. Anyway, was wondering if this needed to be reported as a bug? Seems to cause problems for certain generic uses for the serial type. Matthew Story
В списке pgsql-general по дате отправления: