From: | "Alexander Galler" <galler(at)kuzbass(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file |
Date: | 2006-02-19 16:26:52 |
Message-ID: | 20060219162652.2DBBBF0B04@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2274
Logged by: Alexander Galler
Email address: galler(at)kuzbass(dot)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;
From | Date | Subject | |
---|---|---|---|
Next Message | Davorin Vlasic | 2006-02-20 08:53:23 | BUG #2275: Installation fatal error |
Previous Message | Magnus Hagander | 2006-02-18 21:49:32 | Re: BUG #2271: no privilege to install |