Composite Type with Domain

From: 维 姜 <jw(dot)pgsql(at)sduept(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Composite Type with Domain
Date: 2006-04-04 05:36:43
Message-ID: 1144129003.6769.8.camel@dell.sduept.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-04-04 05:46:53 Re: Composite Type with Domain
Previous Message Rick Craft 2006-04-04 04:26:33 BUG #2374: Installation Error