Re:

On Wed, 2002-09-11 at 14:59, Tom Lane wrote:
> Oliver Elphick <olly(at)lfix(dot)co(dot)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.

In 7.2, this will identify the functions that need to be dumped as
language handlers:

junk=# SELECT p.proname
junk-# FROM pg_proc AS p, pg_language AS l
junk-# WHERE l.lanplcallfoid = p.oid AND l.lanplcallfoid != 0;
proname
----------------------
plperl_call_handler
plpgsql_call_handler
pltcl_call_handler
(3 rows)

> > 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?

year INTEGER DEFAULT date_part('year',CURRENT_TIMESTAMP)

> > 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.

Is it not enough to defer all views until the end? Why would they be
needed any sooner?

--
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