BUG #14027: n_tup_ins increments regardless of insertion success
| От | matvejchikov@gmail.com |
|---|---|
| Тема | BUG #14027: n_tup_ins increments regardless of insertion success |
| Дата | |
| Msg-id | 20160316215910.5232.53548@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #14027: n_tup_ins increments regardless of insertion
success
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14027
Logged by: Ilya Matveychikov
Email address: matvejchikov@gmail.com
PostgreSQL version: 9.5.1
Operating system: Linux
Description:
postgres=# create table t (name text unique);
postgres=# select n_tup_ins from pg_stat_user_tables where relname='t';
n_tup_ins
-----------
0
postgres=# insert into t (name) values ('a');
INSERT 0 1
postgres=# select n_tup_ins from pg_stat_user_tables where relname='t';
n_tup_ins
-----------
1
postgres=# insert into t (name) values ('b');
INSERT 0 1
postgres=# select n_tup_ins from pg_stat_user_tables where relname='t';
n_tup_ins
-----------
2
postgres=# insert into t (name) values ('a');
ÐШÐÐÐÐ: повÑоÑÑÑÑееÑÑ Ð·Ð½Ð°Ñение клÑÑа наÑÑÑÐ°ÐµÑ Ð¾Ð³ÑаниÑение
ÑникалÑноÑÑи
"t_name_key"
ÐÐÐÐ ÐÐÐÐСТÐ: ÐлÑÑ "(name)=(a)" Ñже ÑÑÑеÑÑвÑеÑ.
postgres=# select n_tup_ins from pg_stat_user_tables where relname='t';
n_tup_ins
-----------
3
В списке pgsql-bugs по дате отправления: