Re: [BUGS] BUG #4322: Problems with field not updatable

2008-07-23 Thread Craig Ringer
Alexandre Caneo wrote: When I select the datas with this instruction "select a.x from a,b where a.z = b.z order by 1" the program run very well and I can insert, update and delete rows. But, when I select any column from table b an error occurs when I try to modify the column value from textbox

[BUGS] BUG #4322: Problems with field not updatable

2008-07-23 Thread Alexandre Caneo
The following bug has been logged online: Bug reference: 4322 Logged by: Alexandre Caneo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: WIN XP Description:Problems with field not updatable Details: I'm using Win XP SP2, VB6 and PostgreS

Re: [BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-23 Thread Tomasz Ostrowski
On 2008-07-23 11:48, valgog wrote: > Another question. Is it possible to change the current Database > LC_CTYPE on the database without recreating it with initdb and > reimporting all the data. No. > I would rather prefer my indexes recreated, rather then reimporting > database (cannot afford su

[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-23 Thread valgog
I checked for de_DE.utf8 (created a test database with initdb) and lower/upper is working correctly there on both 8.2 and 8.3 in different languages On Jul 22, 11:26 am, valgog <[EMAIL PROTECTED]> wrote: > On Jul 21, 4:32 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > > > > Valentine Gogichash

[BUGS] Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

2008-07-23 Thread valgog
On Jul 22, 11:53 am, [EMAIL PROTECTED] (Peter Eisentraut) wrote: > Am Tuesday, 22. July 2008 schrieb valgog: > > > Why Postgres allows creating UNICODE database with the locale, that > > can possibly corrupt my data? > > It doesn't allow it, as of 8.3.  In 8.2 it does, but we have fixed that, for >