Re: Composite Type with Domain

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 维 姜 <jw(dot)pgsql(at)sduept(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Composite Type with Domain
Date: 2006-04-04 05:46:53
Message-ID: 13353.1144129613@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?Q?=E7=BB=B4_?= =?UTF-8?Q?=E5=A7=9C?= <jw(dot)pgsql(at)sduept(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message JiangWei 2006-04-04 13:52:08 Re: Composite Type with Domain
Previous Message 维 姜 2006-04-04 05:36:43 Composite Type with Domain