BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file
От | Alexander Galler |
---|---|
Тема | BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file |
Дата | |
Msg-id | 20060219162652.2DBBBF0B04@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file
|
Список | 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;
В списке pgsql-bugs по дате отправления: