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