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!
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
