Skip site navigation (1) Skip section navigation (2)

'Key violation' error

From: "Csaba" <cs(dot)smela(at)medical-tribune(dot)hu>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: 'Key violation' error
Date: 2005-08-11 22:02:33
Message-ID: 000801c59ec0$61b7c4b0$640aa8c0@csabahomeibm (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Driver version: 08_00_0100, 08_00_0101, 08_00_0102
Database version: 8.03 (Both Windows and Linux )
Encoding : LATIN2 ; collation : hu_HU

App. written in Delphi 7.
Recently upgraded PostgresqglODBC to 08_00 from 07_03_200.

Since then if any varchar field of a dataset (TTable or TQuery) containes non-ASCII chars (hungarian letters) trying to post raises DBEngineErrorr exception with following message: 'Key violation, ERROR: syntax error at or near ""XXX" at character Y'

"XXX" is the ASCII part of the sting while "Y" is a number which value depends on where the first non-ASCII character is located in the string.

You can post strings with pure ASCII chars.  

 07_03_200 and all earlier works perfect.

pgsql-odbc by date

Next:From: Bobby BrewsterDate: 2005-08-12 02:51:26
Subject: HELP: Unrecognized key passed to SQLGetInfo30(#209)
Previous:From: Hans-Jürgen SchönigDate: 2005-08-11 20:08:46
Subject: troubles with configure script on solaris ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group