[BUGS] BUG #14739: Wrong message when unique contraint fail

Поиск
Список
Период
Сортировка
От fbd@datasapiens.com
Тема [BUGS] BUG #14739: Wrong message when unique contraint fail
Дата
Msg-id 20170710131648.7729.77377@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14739: Wrong message when unique contraint fail  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] BUG #14739: Wrong message when unique contraint fail  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14739
Logged by:          Fred BARROUD
Email address:      fbd@datasapiens.com
PostgreSQL version: 9.6.1
Operating system:   Windows 10
Description:

I there,

I am testing PG on this query :

CREATE TABLE T_UNIK (ID INT UNIQUE);

INSERT INTO T_UNIK VALUES (1), (2), (3), (4), (5);

UPDATE T_UNIK SET ID = ID + 1;

I know that PG is unable to do this set based operation properly because it
does it row by row (which is a nonsense since it works on many RDBMS)

But the error message is strongly stupid :
ERROR:  invalid byte sequence for encoding "UTF8": 0xe9 0x71 0x75

I am doing this through PG Admin 4 (v 1.1)

Thanks in advance




--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: fcs1@poczta.onet.pl
Дата:
Сообщение: [BUGS] BUG #14738: ALTER SERVER for foregin servers not working
Следующее
От: Eugene Koon
Дата:
Сообщение: [BUGS] postgresql 96 for Centos 7 download not found