Re: nbsp;[GENERAL]nbsp;Thenbsp;jdbc

Hi, I found the point. The auto_commit flag and jdbc connection pool is some of problem and the current_timestamp is not a now() meanful function. I have to use the CAST(timeofday() as timestamp) to. I refer to the http://archives.postgresql.org/pgsql-jdbc/2006-08/msg00063.php. Thanks.

Re: nbsp;[GENERAL]nbsp;Thenbsp;jdbc

Hi, Thanks for the reply. I still work on it, but i guess this problem may on my application side not the db server. I mean the appserver connection pool or jdbc configuration. I still can not nail it. Because I have another web application with the same iBATIS jdbc configuration to the

[GENERAL] The jdbc and current_timestamp

Hi, all I get a problem with the jdbc and timestamp data column. My postgresql running on the Solaris 10 and version is 8.1.6. The table looks like this, create DOMAIN CURRENTTIME AS TIMESTAMP DEFAULT CURRENT_TIMESTAMP; create table RY_ArticleCollection ( ArtIDINT4

Re: [GENERAL]nbsp;encodingnbsp;problem

Hi Jef,I use the prototype 1.4 to ajax some web pages. I have to encodeURI the post form data especial the string form value, otherwise the server will receive wrong encoding characters.If you can not see the query result in correct web page encoding, maybe the page container of this XUL ajax

Re: [GENERAL]nbsp;Hi,nbsp;Fornbsp;the

ve Yao -原始邮件-发件人:"stevegy" <[EMAIL PROTECTED]>发送时间:2006-10-08 13:19:32收件人:"martijn van oosterhout" <KLEPTOG@SVANA.ORG>,"[EMAIL PROTECTED]" <PGSQL-GENERAL@POSTGRESQL.ORG>抄送:(无)主题:Re:[GENERAL]Hi,FortheUTF-8encoding Hi Martijn, I had

Re: [GENERAL] Hi, For the UTF-8 encoding

? -- Steve Yao -原始邮件-发件人:"Martijn van Oosterhout" <KLEPTOG@SVANA.ORG>发送时间:2006-10-04 17:42:00收件人:"stevegy" <[EMAIL PROTECTED]>抄送:pgsql-general@postgresql.org主题:Re: [GENERAL] Hi, everOn Wed, Oct 04, 2006 at 07:50:12AM +0800, stevegy wrote: My testing da

Re: nbsp;nbsp;nbsp;nbsp;[GENERAL]

0-05 09:50:56收件人:"stevegy" <[EMAIL PROTECTED]>抄送:"martijn van oosterhout" <KLEPTOG@SVANA.ORG>,"[EMAIL PROTECTED]" <PGSQL-GENERAL@POSTGRESQL.ORG>主题:Re:[GENERAL]H "stevegy" [EMAIL PROTECTED] writes: I really want to know why the server side encoding

Re: nbsp;nbsp;[GENERAL]nbsp;Hi,nbs

is diffrent from the LANG=zh_CN.GB18030.I think I still have not a direct way to solve this. Or, maybe, the postgres uses the locale settings from the other than the current postgres user?Any suggestions?-- Steve Yao-原始邮件-发件人:Martijn van Oosterhout 发送时间:2006-10-04 17:42:00收件人:stevegy 抄送:pgsql

Re: nbsp;nbsp;nbsp;[GENERAL]nbsp;H

uot;Martijn van Oosterhout" <KLEPTOG@SVANA.ORG>发送时间:2006-10-04 22:35:41收件人:"stevegy" <[EMAIL PROTECTED]>抄送:"[EMAIL PROTECTED]" <PGSQL-GENERAL@POSTGRESQL.ORG>主题:Re:[GENERAL]Hi,nbs On Wed, Oct 04, 2006 at 09:45:26PM +0800, stevegy wrote: So, now i stop the postgres:

[GENERAL] Hi, everyone. can i ask a question for th e server side encoding GB18030 and sort order?

ut the GBK and GB18030 is "not support". So, how can I fix this issue? any ideas? Thank you everyone. Steve Yao stevegy (at) 126 (dot) com 3G 时 代 来 临 了，坚 决 对 传 统 邮 箱 说 不 ！ 新 一 代 极 速 3G 邮 箱 闪 亮 登 场 ，280 兆 网 盘 免 费 送 ！ 点 击 此 处 注 册

Re: nbsp;[GENERAL]nbsp;Hi,nbsp;ever

for the convert function error.Thank you and have a nice day.-- Steve Yao -原始邮件-发件人:Martijn van Oosterhout 发送时间:2006-10-03 21:51:25收件人:stevegy 抄送:pgsql-general@postgresql.org主题:Re: [GENERAL] Hi, everyone. can i ask a question for th e server side encoding GB18030 and sort