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

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

[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 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 - -

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 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
"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

[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

[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

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

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

[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

[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

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

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