Обсуждение: Crash when working with complex composite_types
PgAdmin: 1.18.1
Postgresql: 9.3.1 32bitCREATE TYPE minithumb AS
(x smallint,
y smallint,
url text);
ALTER TYPE minithumb
OWNER TO root;
CREATE TYPE thumbnail AS
(width smallint,
height smallint,
seconds numeric[],
frames integer[],
"interval" smallint,
"number" smallint,
title text,
format smallint);
ALTER TYPE thumbnail
OWNER TO root;
CREATE TYPE watermark AS
(url text,
x smallint,
y smallint,
width smallint,
height smallint,
opacity smallint);
ALTER TYPE watermark
OWNER TO root;
CREATE TYPE output AS
(width smallint,
height smallint,
minithumbs minithumb[],
watermarks watermark[],
thumbnails thumbnail[],
start_time smallint,
end_time smallint,
title text,
min_width smallint,
min_height smallint);
ALTER TYPE output
OWNER TO root;