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: | Raw Message | Whole Thread | 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 |