Re: [BUGS] BUG #6046: select current_date crashes postgres

2011-05-31 Thread Craig Ringer
So much for my worries about a big long conversation. The short answer from Tom Lane, who committed the fixes to git: Tom Lane wrote: This is the known problem with timezone abbreviations not being initialized correctly on Windows --- anything involving interpreting a "keyword" in datetime inpu

Re: [BUGS] BUG #6046: select current_date crashes postgres

2011-05-31 Thread Craig Ringer
Rikard, I've moved this discussion to the pgsql-hackers mailing list, as I can reproduce the crash you reported and have been able to get a useful-looking crash dump to examine. I removed you from the CC list when I moved the report to -hackers, because there's often quite a burst of mail in

Re: [BUGS] BUG #6046: select current_date crashes postgres

2011-05-31 Thread Craig Ringer
On 1/06/2011 1:28 AM, Rikard Pavelic wrote: The following bug has been logged online: Bug reference: 6046 Logged by: Rikard Pavelic Email address: rikard.pave...@zg.htnet.hr PostgreSQL version: 9.1 beta 1 Operating system: Windows 7 64bit Description:select current_

Re: [BUGS] BUG #6046: select current_date crashes postgres

2011-05-31 Thread Craig Ringer
On 1/06/2011 1:28 AM, Rikard Pavelic wrote: select current_time or select current_date results in postgres crash. Ouch. That's not ideal. Please post the messages output to the postgresql log file from when the backend crashes. You will find the log file in the pg_log directory inside your

Re: [BUGS] BUG #6046: select current_date crashes postgres

2011-05-31 Thread Craig Ringer
Ah, never mind. I can reproduce the crash here on my 32-bit win7 with a 32-bit build of Pg. Looking into it now. -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://

[BUGS] BUG #6046: select current_date crashes postgres

2011-05-31 Thread Rikard Pavelic
The following bug has been logged online: Bug reference: 6046 Logged by: Rikard Pavelic Email address: rikard.pave...@zg.htnet.hr PostgreSQL version: 9.1 beta 1 Operating system: Windows 7 64bit Description:select current_date crashes postgres Details: select curren

Re: [BUGS] BUG #6022: Postgre84+RHEL6+Veritas file system?

2011-05-31 Thread Manoranjan Reddy
I tried, it didn't work. There are no clients connected to, I'm doing this in a test environment. -Manoranjan

Re: [BUGS] Unlogged tables cannot be truncated twice

2011-05-31 Thread Cédric Villemain
2011/5/31 Andres Freund : > On Tuesday, May 31, 2011 03:27:22 Alvaro Herrera wrote: >> Excerpts from Andres Freund's message of lun may 30 20:47:49 -0400 2011: >> > On Tuesday, May 31, 2011 02:35:58 AM Andres Freund wrote: >> > > On Tuesday, May 31, 2011 02:14:00 AM Andres Freund wrote: >> > > > On

Re: [BUGS] Unlogged tables cannot be truncated twice

2011-05-31 Thread Andres Freund
On Tuesday, May 31, 2011 03:27:22 Alvaro Herrera wrote: > Excerpts from Andres Freund's message of lun may 30 20:47:49 -0400 2011: > > On Tuesday, May 31, 2011 02:35:58 AM Andres Freund wrote: > > > On Tuesday, May 31, 2011 02:14:00 AM Andres Freund wrote: > > > > On Tuesday, May 31, 2011 01:56:05