Re:

Oliver Elphick <olly@lfix.co.uk> writes:
> 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.

Okay, we need to do something about that, though I'm not sure I see
a clean solution offhand.

> 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

Hmm ... what was the original coding of the default?

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

This has been a problem all along and will continue to be a problem
for awhile longer.  Sorry.
        regards, tom lane