* BUG #1: => SELECT '(100)':: t_1; t_1 ------- (100) (1 row)
-------------------------------------------------------------------
* BUG #2: => \encoding UTF8 => show server_encoding ; server_encoding
----------------- UTF8 => \encoding ISO_8859_1 => SELECT row(100)::
t_1; server closed the connection unexpectedly This probably means the server terminated abnormally
before or while processing the request. The connection to the server was lost. Attempting reset:
Failed [jw@dell ~]$ locale LANG=zh_CN.UTF-8 LC_CTYPE="zh_CN.UTF-8"
LC_NUMERIC="zh_CN.UTF-8" LC_TIME="zh_CN.UTF-8" LC_COLLATE="zh_CN.UTF-8" LC_MONETARY="zh_CN.UTF-8"
LC_MESSAGES="zh_CN.UTF-8" LC_PAPER="zh_CN.UTF-8" LC_NAME="zh_CN.UTF-8" LC_ADDRESS="zh_CN.UTF-8"
LC_TELEPHONE="zh_CN.UTF-8" LC_MEASUREMENT="zh_CN.UTF-8" LC_IDENTIFICATION="zh_CN.UTF-8" LC_ALL=
在 2006-04-04二的 01:46 -0400,Tom Lane写道:
> 维 姜 <jw.pgsql@sduept.com> writes:
> > => \encoding ISO_8859_1
> > => SELECT row(100):: t_1;
> > server closed the connection unexpectedly
>
> Works for me:
>
> regression=# SELECT row(100):: t_1;
> ERROR: value for domain d_1 violates check constraint "d_1_check"
> regression=# \encoding ISO_8859_1
> regression=# SELECT row(100):: t_1;
> ERROR: value for domain d_1 violates check constraint "d_1_check"
>
> Please provide more details, like your locale and encoding settings.
>
> regards, tom lane
>