BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2274
Logged by:          Alexander Galler
Email address:      galler@kuzbass.net
PostgreSQL version: 8.1.3
Operating system:   Windows XP
Description:        Error in 'CREATE DOMAIN'  SQL command in dump file
Details:

I have created domain 'address_period_tsi':
SET search_path = public, pg_catalog;

CREATE TYPE tsinterval
  (
    INPUT=tsinterval_in,
    OUTPUT=tsinterval_out,
    DEFAULT='',
    INTERNALLENGTH=32,
    ALIGNMENT=int4,
    STORAGE=PLAIN
  );

SET search_path = kladr, pg_catalog;

CREATE DOMAIN address_period_tsi
  AS public.tsinterval
  NOT NULL
  DEFAULT '(-infinity..infinity)';

I have create and load dump file 'test.dump':
pg_dump -U postgres test >test.dump

psql -U postgres -f test.dump -d test

psql:test.dump:415: ERROR:  type "tsinterval" does not exist

In dump file:
CREATE DOMAIN address_period_tsi
  AS public.tsinterval
  NOT NULL
  DEFAULT '(-infinity..infinity)'::tsinterval;

Some result if i have create domain:
CREATE DOMAIN address_period_tsi
  AS public.tsinterval
  NOT NULL
  DEFAULT '(-infinity..infinity)'::tsinterval;

OR:
CREATE DOMAIN address_period_tsi
  AS public.tsinterval
  NOT NULL
  DEFAULT '(-infinity..infinity)'::public.tsinterval;