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 по дате отправления: