I'm trying to use postgreSQL (7.4.2) as an object database by creating a type (with CREATE TYPE, see example below) that consists of several attributes with own data types. Then I tried to create a table (see below) with one columns using my own created data type as data type.

Sadly this does not work, see error-message below.

Do anyone have an idea of what to do?

> CREATE TYPE PersonType AS (
> name VARCHAR(15),
> id INTEGER);


> CREATE TABLE PersonTypeTable (info PersonType, attribut INTEGER);
ERROR: Attribute "info" has composite type persontype