Re: [BUGS] BUG #5278: Postgres hangs / crashes every day

2010-01-15 Thread Murali Mohan Nareddy
Tom and Kevin, Thank you for your quick reply. I am not allowed to uninstall anti virus software on this system but can configure the required exclusions. Anti Virus software being used is Symantec. Do any of the problems I am facing are fixed in a recent release so that I can upgrad

Re: [BUGS] BUG #5278: Postgres hangs / crashes every day

2010-01-15 Thread Kevin Grittner
Murali Mohan Nareddy wrote: > Do any of the problems I am facing are fixed in a recent release > so that I can upgrade to that release? You're taking a big risk if you don't update, even though your immediate problems seem to be caused by the AV software. To view the bugs which have been fixe

Re: [BUGS] Failed to run initdb - not resolved bug 5130

2010-01-15 Thread Robert Haas
On Tue, Jan 12, 2010 at 8:04 AM, Thomas Specker wrote: > Hi all > after a long time of trying to install PostgreSQL with ... > > Computer: > > - Windows2000 (Jurassic Parc, I know ...) > >  -   PostGreSQL 8.3.9 and msi-file >  or PostGreSQL 8.4.2 and one click installer > > - Data in >    /8.4/dat

[BUGS] BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

2010-01-15 Thread Jodi Escalante
The following bug has been logged online: Bug reference: 5281 Logged by: Jodi Escalante Email address: jescala...@assistgroup.com PostgreSQL version: 8.3 and 8.4 Operating system: Linux Description:Timestamp fields not inserting from 8.3 to 8.4 Details: Hi - I am tr

Re: [BUGS] BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

2010-01-15 Thread Heikki Linnakangas
Jodi Escalante wrote: > I am erroring out on record number one on the first timestamptz field. I > have tested several different tables and they all error out on the > timestamptz field. Below is a sample SQL. > > I downloaded the most recent JDBC driver and that did not help. > > INSERT

Re: [BUGS] BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

2010-01-15 Thread Kevin Grittner
"Jodi Escalante" wrote: > INSERT INTO assessment (id, created, taken, current_weight, note, > assessment_type, stay_id, contact_id, estimated_discharge_date, > cond_chf, cond_pulm_heart, cond_endocrine_other, cond_skin_temp, > ) VALUES ( 50, 2008-01-11 15:06:40.257000 -07:00:00, > 2008-01-11

Re: [BUGS] BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

2010-01-15 Thread Chris Travers
On Fri, Jan 15, 2010 at 9:38 AM, Kevin Grittner wrote: > "Jodi Escalante" wrote: > >> INSERT INTO assessment (id, created, taken, current_weight, note, >> assessment_type, stay_id, contact_id, estimated_discharge_date, >> cond_chf, cond_pulm_heart, cond_endocrine_other, cond_skin_temp, >> ) VALUE