Re:

On Wed, 2002-09-11 at 05:20, Tom Lane wrote:
> Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> writes:
> > On Tuesday 10 September 2002 11:43 pm, Tom Lane wrote:
> >> AFAIK, we did what we could on that front in 7.2.1. If you have ideas
> >> on how we can retroactively make things better, I'm all ears ...
>
> > So this release is going to be the royal pain release to upgrade to?
>
> pg_dumpall from a 7.2 db, and reload into 7.2, is broken if you have
> mixed-case DB names. AFAIK it's okay if you use a later-than-7.2
> pg_dumpall, or reload with a later-than-7.2 psql. If Oliver's got
> info to the contrary then he'd better be more specific about what
> he thinks should be fixed for 7.3. Griping about the fact that 7.2.0
> is broken is spectacularly unproductive at this point.

I ran pg_dumpall from 7.3 on the 7.2 database. So I am talking about
the pg_dump that is now being beta-tested. Because of the major changes
in 7.3, the 7.2 dump is not very useful. I am *not* complaining about
7.2's pg_dump!

Let me reiterate. I got these problems dumping 7.2 data with 7.3's
pg_dumpall:

1. The language handlers were dumped as opaque; that needs to be
changed to language_handler.

2. The dump produced:
CREATE TABLE cust_alloc_history (
...
"year" integer DEFAULT date_part('year'::text,
('now'::text)::timestamp(6) with time zone) NOT NULL,
...
ERROR: Column "year" is of type integer but default expression is
of type double precision
You will need to rewrite or cast the expression

3. A view was created before one of the tables to which it referred.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I am crucified with Christ; nevertheless I live; yet
not I, but Christ liveth in me; and the life which I
now live in the flesh I live by the faith of the Son
of God, who loved me, and gave himself for me."
Galatians 2:20