Roberto Mello suggested I post my problem here. He suggested Tom Lane
might take a look...

I dumped an 7.0.3 database and restored that to rc2, which went fine after
a bit of reordering help (It was an OpenACS table set).

Now when I dump the same database with rc2 (or 4) I get a
different set of ordering problems.
Some five functions are used in views before their definitions. In the
original (7.0) dump they were in the correct order, but rc2/4 (the only
ones I tried) got it wrong. The original OIDs for the
functions in the 7.1 dump are lower than those of the views. I do not know
what is wrong. I can reproduce the results on another box. I have a copy
of the relevant dumps (both the initial 7.0.3 >> 7.1rc2 and the rc4 >> rc4
dump), anyone interested may have them for testing.

I compiled on a fairly clean RH6.2/AMD-K6/256M box with nothing more than
./configure; make; make install (so that it ended up in /usr/local/pgsql)
The box has the 7.0.3 RPMs installed, 7.1 runs on port 5433 and has a
separate postmaster account (postgr71).

Regards,
Pascal Scheffers.


-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT$/MU/ED/S/P d(++) s+:+ a?(-) C++ UL++++ P+(--) L+++ E(++) W+++ N++ o? K
w++$(---) O- M-- V-- PS@ PE Y+(-) PGP(++) t+@ 5++ X- R tv b++ DI@ D? G e++
h---(-/----) y+++
------END GEEK CODE BLOCK------
co-hosting is for sissies. get your own machine out there. NOW!



Wed, 11 Apr 2001 18:53:55 +0200 (CEST)
Pascal Scheffers <pascal@scheffers.net>
pg_dump ordering problem (rc4)
At 18:53 11/04/01 +0200, Pascal Scheffers wrote:
> I have a copy
>of the relevant dumps (both the initial 7.0.3 >> 7.1rc2 and the rc4 >> rc4
>dump), anyone interested may have them for testing.

Yes please.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Thu, 12 Apr 2001 03:12:38 +1000
Philip Warner <pjw@rhyme.com.au>
Re: pg_dump ordering problem (rc4)
Pascal Scheffers <pascal@scheffers.net> writes:
> Some five functions are used in views before their definitions. In the
> original (7.0) dump they were in the correct order, but rc2/4 (the only
> ones I tried) got it wrong. The original OIDs for the
> functions in the 7.1 dump are lower than those of the views. I do not know
> what is wrong. I can reproduce the results on another box. I have a copy
> of the relevant dumps (both the initial 7.0.3 >> 7.1rc2 and the rc4 >> rc4
> dump), anyone interested may have them for testing.

Please.  Philip Warner would likely want to see them too.

			regards, tom lane

Fri, 13 Apr 2001 14:28:46 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump ordering problem (rc4) 

Tom,

> > dump), anyone interested may have them for testing.
>
> Please.  Philip Warner would likely want to see them too.
I don't have his email address... but I am quite willing to send it.

Pascal.




Fri, 13 Apr 2001 22:25:46 +0200 (CEST)
Pascal Scheffers <pascal@scheffers.net>
Re: pg_dump ordering problem (rc4) 