* 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
[EMAIL PROTECTED] ~]$ 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写道：
> =?UTF-8?Q?=E7=BB=B4_?= =?UTF-8?Q?=E5=A7=9C?= <[EMAIL PROTECTED]> 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
>
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
