From: "Josh Berkus" <[EMAIL PROTECTED]>
> Richard,
> > Try having a look at the order the tables get inserted esp. with
> > regard to
> > any foreign keys etc. - I'm not sure pgdump is that clever about such
> > things.
>
> Thanks. I did try that; however:
> 1. Even trying re-loading the tables
Hi,
>In an effort to do some general cleanup in my database functions, I
>dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text
>files.
I'm using a similar method for my own project. But I dump the data with
the -d or -D option. This ist not as fast as the raw copy but more fle
Richard,
>
> Try having a look at the order the tables get inserted esp. with
> regard to
> any foreign keys etc. - I'm not sure pgdump is that clever about such
> things.
Thanks. I did try that; however:
1. Even trying re-loading the tables twice did not work, as it should
have with missing f
From: "Josh Berkus" <[EMAIL PROTECTED]>
> Folks,
>
> In an effort to do some general cleanup in my database functions, I
> dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text
> files.
>
> I editied and restored the schema fine. However, when I attemped to
> restore the data (v
Folks,
In an effort to do some general cleanup in my database functions, I
dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text
files.
I editied and restored the schema fine. However, when I attemped to
restore the data (via \i filename), it failed selectively; some tables
wer
