Re: Composite Type with Domain

* 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
>