Thread: datetime local bug

Hi

I discovered a bug in PgAdmin II 1.2.0.

I have set my default locale on my Win2k to "faroese" and by default it
uses "." to separate time values and not ":" as i probably does in english.

So, your "10:15:30" displays by default on my machine as "10.15.30". The
problem is that when I view data in a table and edit data I can't save
the record if one of the columns is a datetime column. I even tried to
change the displayed "." to ":", but that doesn't work either. The only
solution is to go into the Controlpanel, Reginal Options , Time and
change "time separator" to ":". Then it works perfectly, but that
shouldn't by necessary ;-)

Poul L. Christiansen

BTW: thanks for at great program :-)

> -----Original Message-----
> From: Poul L. Christiansen [mailto:poulc@cs.auc.dk]
> Sent: 2. august 2002 15.31
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] datetime local bug
>
>
> Hi
>
> I discovered a bug in PgAdmin II 1.2.0.
>
> I have set my default locale on my Win2k to "faroese" and by
> default it
> uses "." to separate time values and not ":" as i probably
> does in english.

Hi Poul,

I have just committed a fix to CVS for this problem. It is actually
caused by a combination of PostgreSQL not recognising the .'s and
Microsoft's VB Runtime helpfully converting the :'s that pgAdmin uses
into the .'s for the current regional settings!

This fix will be in the next release, or you can download snapshot
binaries from http://cvs.pgadmin.org/ in the binaries folder. See the
README for installation instructions.

Regards, Dave.