BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file

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;

Responses

Browse pgsql-bugs by date

  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