Re: Major Problems with pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Major Problems with pg_dump
Date: 2005-01-11 17:57:16
Message-ID: 1701.1105466236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

=?iso-8859-1?Q?K=D6PFERL_Robert?= <robert(dot)koepferl(at)sonorys(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-01-11 18:38:18 DELETE & INSERT in a function
Previous Message Michael Fuhr 2005-01-11 17:31:18 Re: Major Problems with pg_dump