BUG #14739: Wrong message when unique contraint fail

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

Responses

Browse pgsql-bugs by date

  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