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
Список
Дерево обсуждения
BUG #14027: n_tup_ins increments regardless of insertion success matvejchikov@gmail.com
Re: BUG #14027: n_tup_ins increments regardless of insertion
success Vik Fearing <vik@2ndquadrant.fr>
Re: BUG #14027: n_tup_ins increments regardless of insertion success "David G. Johnston" <david.g.johnston@gmail.com>
Re: BUG #14027: n_tup_ins increments regardless of insertion success Ilya Matveychikov <matvejchikov@gmail.com>
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 по дате отправления
От: srivathson.k@zohocorp.com
Дата: