[BUGS] BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file

[Alexander Galler]

The following bug has been logged online:

Bug reference:      2274
Logged by:          Alexander Galler
Email address:      [EMAIL PROTECTED]
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;

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings