Thread: Restoring table with array

Restoring table with array

From
BELLON Michel
Date:
Hi all,

Restoring a table with the following file

 <<restore.txt>>
I obtain the error
ERROR: pg_atoi: error in "{{0.22,0.2,10 ... etc
with INSERT INTO evtransftherm .... etc


+--------------------------------------------------------------+
| version                                                      |
+--------------------------------------------------------------+
| PostgreSQL 7.1.2 on i686-pc-cygwin, compiled by GCC 2.95.3-4 |
+--------------------------------------------------------------+

and the same with 7.1.3 on a Mandrake distribution

Help !!!


Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35


Attachment

Re: Restoring table with array

From
Stephan Szabo
Date:
On Mon, 8 Oct 2001, BELLON Michel wrote:

> Hi all,
>
> Restoring a table with the following file
>
>  <<restore.txt>>
> I obtain the error
> ERROR: pg_atoi: error in "{{0.22,0.2,10 ... etc
> with INSERT INTO evtransftherm .... etc
>
>
> +--------------------------------------------------------------+
> | version                                                      |
> +--------------------------------------------------------------+
> | PostgreSQL 7.1.2 on i686-pc-cygwin, compiled by GCC 2.95.3-4 |
> +--------------------------------------------------------------+
>
> and the same with 7.1.3 on a Mandrake distribution

Can you send a complete example?  The given one inherits from
a non-existant table.  Did you perhaps change etalverif at all?

Re: Restoring table with array

From
BELLON Michel
Date:
Sorry
 <<etalverif.txt>>


Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35

> -----Message d'origine-----
> De:    Stephan Szabo [SMTP:sszabo@megazone23.bigpanda.com]
> Date:    lundi 8 octobre 2001 18:15
> À:    BELLON Michel
> Cc:    pgsql-bugs@postgresql.org
> Objet:    Re: [BUGS] Restoring table with array
>
>
>
> On Mon, 8 Oct 2001, BELLON Michel wrote:
>
> > Hi all,
> >
> > Restoring a table with the following file
> >
> >  <<restore.txt>>
> > I obtain the error
> > ERROR: pg_atoi: error in "{{0.22,0.2,10 ... etc
> > with INSERT INTO evtransftherm .... etc
> >
> >
> > +--------------------------------------------------------------+
> > | version                                                      |
> > +--------------------------------------------------------------+
> > | PostgreSQL 7.1.2 on i686-pc-cygwin, compiled by GCC 2.95.3-4 |
> > +--------------------------------------------------------------+
> >
> > and the same with 7.1.3 on a Mandrake distribution
>
> Can you send a complete example?  The given one inherits from
> a non-existant table.  Did you perhaps change etalverif at all?
>

Attachment

Re: Restoring table with array

From
Tom Lane
Date:
BELLON Michel <Michel.Bellon@lcie.fr> writes:
> I obtain the error
> ERROR: pg_atoi: error in "{{0.22,0.2,10 ... etc
> with INSERT INTO evtransftherm .... etc

It's impossible to reproduce this problem with your given example,
since you didn't provide the definition of the parent table etalverif.

However, I'm guessing that your problem may arise from having done
ALTER TABLE ADD COLUMN on the parent at some time in the past, leading
to an inconsistency in the column ordering of the child --- dropping and
recreating the child will mean it has a different column ordering than
before.  Unfortunately pg_dump is not very smart about this situation.
AFAIK the only way to produce a reloadable dump in this case is to use
pg_dump -D (dump data as INSERTs with fully specified column names).

            regards, tom lane