| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
| Cc: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Laurette Cisneros <laurette(at)nextbus(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2002-09-11 13:59:36 |
| Message-ID: | 27519.1031752776@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2002-09-11 14:29:09 | Re: |
| Previous Message | snpe | 2002-09-11 13:45:54 | Re: problem with new autocommit config parameter and jdbc |