[Condor-users] Condor Quill Error in access Postgresql

["赵坤" <zhaokun@xxxxxxxxxxxxx>]

hi,
	
	After setting up Quill, I found some errors in QuillLog like this
	
1/3 19:47:26 [SQL EXECUTION ERROR2] ERROR:  date/time field value out of range: "1/3/2009 19:47:26 CST"
HINT:  Perhaps you need a different "datestyle" setting.

1/3 19:47:26 [SQL: UPDATE currencies SET lastupdate = '1/3/2009 19:47:26 CST' WHERE datasource = 'mgt1.hotsim.local']
1/3 19:47:26 Update currency --- ERROR [SQL] UPDATE currencies SET lastupdate = '1/3/2009 19:47:26 CST' WHERE datasource = 'mgt1.hotsim.local'


Then I try to execute the sql in Postgresql,this erro still exists.
When I change the date/time style ,it successfully executed.
	
UPDATE currencies SET lastupdate = '2009-1-3 19:47:26 CST' WHERE datasource = 'mgt1.hotsim.local'
	
	
Condor Version:7.2.0
Postgresql Version:8.3.5

	Thanks.
　　　　　　	　Zhaokun
			   Beijing Hotsim Technology Co.,Ltd
			   zhaokun@xxxxxxxxxxxxx
　　　　　　　　　　2009-01-07