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

"Alexander Galler" <galler@kuzbass.net> writes:
> 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;

I can't duplicate this --- for me, pg_dump produces

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

which reloads just fine.  Could you provide a more complete example?

            regards, tom lane