Re: [BUGS] BUG #2879: RPM: wrong quoting of error message about

2007-01-12 Thread Devrim GUNDUZ
Hi, On Wed, 2007-01-10 at 21:43 +, Meetesh Karia wrote: > PostgreSQL version: 8.0.10 > Operating system: Centos-4.2 > Description:RPM: wrong quoting of error message about old database > format after upgrading I changed that message for PGDG 8.0 RPMs. The other releases do not have

Re: [BUGS] BUG #2882: jdbc driver: date returned from a stored proc is incorrect

2007-01-12 Thread Alvaro Herrera
Ravi Periasamy wrote: > I do not think this is a server issue, seems like a > driver issue. When I connect to the DB from RHEL4 > through the driver (running on RHEL4) it works. But, > when the driver is running on RHEL3 it fails. Oh, I hadn't realized that both clients were connecting to the same

[BUGS] BUG #2883: TCP Keep Alive not enabled even after setting it in postresql.conf

2007-01-12 Thread Christopher Brian Jurado
The following bug has been logged online: Bug reference: 2883 Logged by: Christopher Brian Jurado Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows 2000/XP Description:TCP Keep Alive not enabled even after setting it in postresql.conf

[BUGS] BUG #2884: Bug in rs.getInt(colname) when JMV language is Turkish

2007-01-12 Thread Ismail Cansiz
The following bug has been logged online: Bug reference: 2884 Logged by: Ismail Cansiz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Centos Linux Description:Bug in rs.getInt(colname) when JMV language is Turkish Details: I have run a qu

Re: [BUGS] BUG #2882: jdbc driver: date returned from a stored proc is incorrect

2007-01-12 Thread Ravi Periasamy
I do not think this is a server issue, seems like a driver issue. When I connect to the DB from RHEL4 through the driver (running on RHEL4) it works. But, when the driver is running on RHEL3 it fails. Anyways, here's the output: [EMAIL PROTECTED] pgsql]# pg_controldata `pwd`/data pg_control versi

Re: [BUGS] BUG #2882: jdbc driver: date returned from a stored proc is incorrect

2007-01-12 Thread Ravi Periasamy
A after thought- I was working with Oliver Cloud on a similar issue and he has a fix for that issue, that would solve this as well. Basically the changeTime() method called from Statement.getDate(int, Calendar) is causing the problem. Make sure, the code from ResultSet.getDate(int, Calendar) is

[BUGS] BUG #2885: to_char function

2007-01-12 Thread Akio Iwaasa
The following bug has been logged online: Bug reference: 2885 Logged by: Akio Iwaasa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: Redhat EL ES 3.0 Description:to_char function Details: When I've used "to_char" function to convert "Dat

[BUGS] PG unexpected crash

2007-01-12 Thread Zubkovsky, Sergey
select version(); "PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" pg_log: 2007-01-12 16:41:23 STATEMENT: EXPLAIN COPY "MsgRoot" TO 'C:/Program Files/PostgreSQL/8.2/data/MsgRoot.txt' 2007-01-12 17:16:04 LOG: checkpoints are occurring too frequen

Re: [BUGS] BUG #2885: to_char function

2007-01-12 Thread Tom Lane
"Akio Iwaasa" <[EMAIL PROTECTED]> writes: > When I've used "to_char" function to convert "Date" to > "century" format text, '2000-01-01' was converted in > the 21st century. > postgres=# select to_char('2000-01-01'::date, 'CC') ; > to_char > - > 21 > (1 row) I'm not entirely sure

Re: [BUGS] BUG #2885: to_char function

2007-01-12 Thread Bruce Momjian
I updated our documentation for CC: century component of year (minimum 2 digits) --- Tom Lane wrote: > "Akio Iwaasa" <[EMAIL PROTECTED]> writes: > > When I've used "to_char" function to convert "Date" to > > "cent

Re: [BUGS] BUG #2885: to_char function

2007-01-12 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I updated our documentation for CC: > century component of year (minimum 2 digits) Updating the documentation isn't a solution; either the code is correct or it's not, and I rather suspect it's not (it's incompatible with EXTRACT(CENTURY) for exa

Re: [BUGS] BUG #2885: to_char function

2007-01-12 Thread Douglas Toltzman
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the OLAP option JServer Release 9.2.0.4.0 - Production select ordh_dtinral, to_char(ordh_dtinral,'CC YY') from ordheader where ordh_dtinral between '01-Jan-2000' and '01-Mar-2000'; ORDH_DTIN TO_CH - -

[BUGS] Missing error message on missing ssl-key-files

2007-01-12 Thread Harald Armin Massa
PostgreSQL 8.1.5 and 8.2.1 both on W2K3, installed from the standard win32 msi installer. Problem: in postgresql.conf ssl=on but the files server.key etc. are NOT present. Result: PostgreSQL service does not start. And no error message in any log I could access: nothing in the Windows Event

Re: [BUGS] BUG #2885: to_char function

2007-01-12 Thread Tom Lane
Douglas Toltzman <[EMAIL PROTECTED]> writes: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the OLAP option > JServer Release 9.2.0.4.0 - Production > select ordh_dtinral, to_char(ordh_dtinral,'CC YY') from ordheader > where ordh_dtinral between '01-Jan-2000' and '01-M

Re: [BUGS] BUG #2885: to_char function

2007-01-12 Thread Tom Lane
"Akio Iwaasa" <[EMAIL PROTECTED]> writes: > When I've used "to_char" function to convert "Date" to > "century" format text, '2000-01-01' was converted in > the 21st century. I've patched this in HEAD and 8.2 branch. regards, tom lane ---(end of b