pg_dump ordering problem (rc4)

From: Pascal Scheffers <pascal(at)scheffers(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump ordering problem (rc4)
Date: 2001-04-11 16:53:55
Message-ID: Pine.LNX.4.32L2.0104111839040.10986-100000@io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2001-04-11 17:12:38 Re: pg_dump ordering problem (rc4)
Previous Message Peter Eisentraut 2001-04-11 16:49:45 Re: age() function documentation