| From: | fbd(at)datasapiens(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | fbd(at)datasapiens(dot)com |
| Subject: | BUG #14739: Wrong message when unique contraint fail |
| Date: | 2017-07-10 13:16:48 |
| Message-ID: | 20170710131648.7729.77377@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14739
Logged by: Fred BARROUD
Email address: fbd(at)datasapiens(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eugene Koon | 2017-07-10 16:03:30 | postgresql 96 for Centos 7 download not found |
| Previous Message | fcs1 | 2017-07-10 11:39:17 | BUG #14738: ALTER SERVER for foregin servers not working |