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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Davorin Vlasic"
Дата:
Сообщение: BUG #2275: Installation fatal error
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: BUG #2256: install problem