[BUGS] constraints & tableoid [pgsql8.1]

jw=# CREATE TABLE base ( CHECK (tableoid = 'base'::regclass) ); CREATE TABLE jw=# \d base Table "public.base" Column | Type | Modifiers +--+--- Check constraints: "base_tableoid_check" CHECK (tableoid = 'base'::regclass::oid) jw=# INSERT INTO base DEFAULT VALUES ; ERRO

[BUGS] contrib/intarray/_int_gist.c

In "g_int_compress" : int*dr; ... memmove((void *) &dr[cand - 1], (void *) &dr[cand + 1], (len - cand - 1) * sizeof(int)); Should be int32 *dr; ... memmove((void *) &dr[cand - 1], (void *) &dr[cand + 1], (len - cand - 1) * sizeof(int32)); --

[BUGS] Composite Type with Domain

# 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