Re: Major Problems with pg_dump - Mailing list pgsql-novice

From Tom Lane
Subject Re: Major Problems with pg_dump
Date
Msg-id 1701.1105466236@sss.pgh.pa.us
Whole thread Raw
In response to Re: Major Problems with pg_dump  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-novice
=?iso-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at> writes:
> Here's one example.

> We have a cdr_type in line 64
> CREATE TYPE cdr_type AS (
> ...
>     "Charge" charge_type,
> ...
> );

> while charge_type gets defined in line 86:

> CREATE DOMAIN charge_type AS numeric(9,4)
>     CONSTRAINT "$1" CHECK ((VALUE >= (0)::numeric));

Ah --- it was missing the dependency in this case, and ordering the
types by name by default.  Fixed; thanks for the report!

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Major Problems with pg_dump
Next
From: "Keith Worthington"
Date:
Subject: DELETE & INSERT in a function