# select version(); version -------------------------------------------------------------------------------------------- PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13) (1 row)
simple example: # create type a as (a text,b int); CREATE TYPE # create type a as (a text,b int); ERROR: relation "a" already exists seems like ERROR: type "a" already exists would be better. Thanks Jim ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org