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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander Galler" <galler(at)kuzbass(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file
Date: 2006-02-20 23:15:44
Message-ID: 29527.1140477344@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alexander Galler" <galler(at)kuzbass(dot)net> writes:
> 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;

I can't duplicate this --- for me, pg_dump produces

CREATE DOMAIN address_period_tsi AS public.tsinterval NOT NULL DEFAULT '(-infinity..infinity)'::public.tsinterval;

which reloads just fine. Could you provide a more complete example?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Huxton 2006-02-21 09:49:17 Re: BUG #2272: stop
Previous Message Fernando Marques 2006-02-20 22:14:11 BUG #2276: No consigo tirar backup/Select na tabela