From: | Daniel Cristian Cruz <danielcristian(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | ISBN: dump from 64bits and restore on 32 bits fail, Datum? |
Date: | 2011-08-10 22:30:45 |
Message-ID: | CACffM9F-YyRYDAxPz3p4EevuiJE3hA1nsOo=Fc=ogOKeE4piEw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
I'm in a project where there is one development server with 32bits
architecture and all the others are 64 bits.
The server where I generate the base models (in sense of version) is a 64
bit. Dump and restore from this machine to all others 64bits development
servers works well. When I try to restore it in the 32 bits server, it
returns the following errors:
[pg9(at)server ~]$ createdb isbn -T template0
[pg9(at)server ~]$ pg_restore -d isbn /tmp/isbn.backup
*ERROR: internal size 8 is invalid for passed-by-value type*
STATEMENT: CREATE TYPE ean13 (
INTERNALLENGTH = 8,
INPUT = ean13_in,
OUTPUT = public.ean13_out,
ALIGNMENT = double,
STORAGE = plain,
PASSEDBYVALUE
);
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 550; 1247 1184851 TYPE
ean13 pg9
pg_restore: [archiver (db)] could not execute query: ERROR: internal size 8
is invalid for passed-by-value type
Command was: CREATE TYPE ean13 (
INTERNALLENGTH = 8,
INPUT = ean13_in,
OUTPUT = public.ean13_out,
ALIGNMENT = double,
...
ERROR: type "ean13" is only a shell
STATEMENT: COMMENT ON TYPE ean13 IS 'International European Article Number
(EAN13)';
pg_restore: [archiver (db)] Error from TOC entry 2254; 0 0 COMMENT TYPE
ean13 pg9
pg_restore: [archiver (db)] could not execute query: ERROR: type "ean13" is
only a shell
Command was: COMMENT ON TYPE ean13 IS 'International European Article
Number (EAN13)';
*ERROR: internal size 8 is invalid for passed-by-value type*
STATEMENT: CREATE TYPE isbn (
INTERNALLENGTH = 8,
INPUT = isbn_in,
OUTPUT = public.isn_out,
ALIGNMENT = double,
STORAGE = plain,
PASSEDBYVALUE
);
pg_restore: [archiver (db)] Error from TOC entry 562; 1247 1184867 TYPE isbn
pg9
...
And many errors after these ones.
I guess it's a bug in isbn code since when not using isbn/issn contrib
modules the errors doesn't shows up.
Naive I was trying to force Datum size to 8 and recompile postgresql for the
32 bits server. It doesn't work this way. :)
Now I request some help from some PostgreSQL Olympian Gods... :)
Regards,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-08-10 22:58:49 | Re: ISBN: dump from 64bits and restore on 32 bits fail, Datum? |
Previous Message | Tom Lane | 2011-08-10 00:42:54 | Re: BUG #6158: documentation error (grammar/typo) |