Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Davorin VlasicDate: 2006-02-20 08:53:23
Subject: BUG #2275: Installation fatal error
Previous:From: Magnus HaganderDate: 2006-02-18 21:49:32
Subject: Re: BUG #2271: no privilege to install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group