BUG #14909: nextval() bug

Поиск
Список
Период
Сортировка
От personal@rysmax.com
Тема BUG #14909: nextval() bug
Дата
Msg-id 20171115105136.1473.62937@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14909: nextval() bug  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14909
Logged by:          Max Rys
Email address:      personal@rysmax.com
PostgreSQL version: 10.1
Operating system:   macOS 10.12.6
Description:

I run this simple queries on PostgeSQL 9.6 and 10.1:

DROP TABLE IF EXISTS "user";
CREATE TABLE "user" (
  id serial primary key not null,
  email varchar(64) not null
);
INSERT INTO "user" (id, email) VALUES ('1', 'admin@example.com');
INSERT INTO "user" (id, email) VALUES ('2', 'user@example.com');

All done without errors.



When i try to run the query bellow:

INSERT INTO "user" (email) VALUES ('test@example.com');

and got the next error in pgAdmin and from the PHP:

ERROR:  duplicate key value violates unique constraint "user_pkey"
DETAIL:  Key (id)=(1) already exists.

but when i try to run this query 2 times the query executed without errors
on 3rd time.



I think this is a bug in nextval() function.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeevan Chalke
Дата:
Сообщение: Re: [BUGS] BUG #14890: Error grouping by same column twice using FDW
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BUG #14909: nextval() bug