Composite Type with Domain - Mailing list pgsql-bugs

From 维 姜
Subject Composite Type with Domain
Date
Msg-id 1144129003.6769.8.camel@dell.sduept.com
Whole thread Raw
Responses Re: Composite Type with Domain  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
# pg8.1.3

=> CREATE DOMAIN d_1 integer CHECK (VALUE < 10);
=> CREATE TYPE t_1 AS (m d_1);
=> SELECT '(100)':: t_1; t_1
-------(100)
(1 row)

=> SELECT row(100):: t_1;
错误:  域 d_1 的值违反了检查约束 "d_1_check"


=> \encoding ISO_8859_1
=> SELECT row(100):: t_1;
server closed the connection unexpectedly       This probably means the server terminated abnormally       before or
whileprocessing the request. 
The connection to the server was lost. Attempting reset: Failed.




pgsql-bugs by date:

Previous
From: Jim Nasby
Date:
Subject: Re: BUG #2365: can't install
Next
From: Tom Lane
Date:
Subject: Re: Composite Type with Domain