ISBN: dump from 64bits and restore on 32 bits fail, Datum?

Поиск
Список
Период
Сортировка
От Daniel Cristian Cruz
Тема ISBN: dump from 64bits and restore on 32 bits fail, Datum?
Дата
Msg-id CACffM9F-YyRYDAxPz3p4EevuiJE3hA1nsOo=Fc=ogOKeE4piEw@mail.gmail.com
обсуждение исходный текст
Ответы Re: ISBN: dump from 64bits and restore on 32 bits fail, Datum?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@server ~]$ createdb isbn -T template0
[pg9@server ~]$ pg_restore -d isbn /tmp/isbn.backup
*ERROR:  internal size 8 is invalid for passed-by-value type*
STATEMENT:  CREATE TYPE ean13 (
            INTERNALLENGTH =3D 8,
            INPUT =3D ean13_in,
            OUTPUT =3D public.ean13_out,
            ALIGNMENT =3D double,
            STORAGE =3D 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 =3D 8,
    INPUT =3D ean13_in,
    OUTPUT =3D public.ean13_out,
    ALIGNMENT =3D 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 =3D 8,
            INPUT =3D isbn_in,
            OUTPUT =3D public.isn_out,
            ALIGNMENT =3D double,
            STORAGE =3D 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,
--=20
Daniel Cristian Cruz
=E3=82=AF=E3=83=AB=E3=82=BA =E3=82=AF=E3=83=AA=E3=82=B9=E3=83=81=E3=82=A2=
=E3=83=B3 =E3=83=80=E3=83=8B=E3=82=A8=E3=83=AB

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6158: documentation error (grammar/typo)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ISBN: dump from 64bits and restore on 32 bits fail, Datum?