From: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
---|---|
To: | |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Major Problems with pg_dump |
Date: | 2005-01-11 15:47:13 |
Message-ID: | ED4E30DD9C43D5118DFB00508BBBA76EB1653C@neptun.sonorys.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Ok, now i see. I didn't realize that I am using an 8.0 pg_dump.
This occoured due a communication gap in our team. In trueth we have 7.4 as
server again.
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));
sorry but I must't give you the whole dump
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Dienstag, 11. Jänner 2005 16:12
> To: KÖPFERL Robert
> Cc: pgsql-novice(at)postgresql(dot)org
> Subject: Re: [NOVICE] Major Problems with pg_dump
>
>
> =?iso-8859-1?Q?K=D6PFERL_Robert?= <robert(dot)koepferl(at)sonorys(dot)at> writes:
> > 2. Dumping schema+data types and domains are dumped in the
> wrong order.
> > Types don't get defined due to missing domains. Hmmm?
>
> > 3. pg_dump writes FUNCTIONs with $$ instead of ' as frame
> for their body.
> > However postgres seems to not like that. Why, how, I dunno?
>
> Apparently you are dumping with an 8.0 pg_dump and trying to
> load into a
> previous-generation backend. That is never guaranteed to
> work and it's
> particularly likely to not work from 8.0 to older backends.
>
> However, 8.0 pg_dump should have solved the incorrect-dump-order
> problem. Could we see a specific example of #2 occurring with the 8.0
> dump?
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Worthington | 2005-01-11 17:19:14 | Writing to dependent tables in a function |
Previous Message | Tom Lane | 2005-01-11 15:12:27 | Re: Major Problems with pg_dump |