The columns are not in the right order.
You could re-arrange the ar and parts tables or save the schema and
re-create your new database from the existing. This way they will match.
Or reorder the columns in the sql/Pg-tables.sql file to match yours and
create a new dataset.
Dieter Simader http://www.sql-ledger.org (780) 472-8161
DWS Systems Inc. Accounting Software Fax: 478-5281
=========== On a clear disk you can seek forever ===========
On Sun, 3 Mar 2002, David A. Bandel wrote:
> Hey folks,
>
> Got a question about the backup and restore.
>
> I have one system I've upgraded from like version 1.2 all the way to
> current (1.8.2). Previously I did backups (OK, still do) from a command
> line and they worked fine. Thought I'd give Dieter's backup a try.
>
> So I installed another box, set up the database (empty), and tried to
> restore from the backup file (after all, that's what I'd do if the hard
> drive crashed).
>
> However, some tables are giving me fits. Here are the error messages from
> the restore (I used a command line \i <filename.db> to restore):
> psql:pananix.db:347: ERROR: copy: line 1, Bad date external
> representation '10071' psql:pananix.db:347: PQendcopy: resetting
> connection and:
> psql:pananix.db:671: ERROR: copy: line 1, Bad float8 input format
> '06-02-2002' psql:pananix.db:671: PQendcopy: resetting connection
>
> I suspect for some reason the columns are being input in the wrong order.
> The specific tables are: DELETE FROM ar;
> COPY ar FROM stdin;
> 10091 1001 21-11-2000 10071 0 502.5 500 502.5
> 07-12-2000 20-12-2000 1 FOB David 30 \N \N
> \N
>
> and:
> DELETE FROM parts;
> COPY parts FROM stdin;
> 10264 LS-Desktop Complete Linux System Installed & Configured ea
> 550 795 \N 06-02-2002 3.5 -1 \N 0
> 0 0 0 10058 10063 10046 \N 0
>
> When I created the original database, it only had the default table, so
> that's what I set up via the admin screen with 1.8.2 (Default dataset). I
> figured it'd be closest to the original from 1.2 (with all the updates).
>
> Thoughts, ideas, ???
>
> Thanx,
>
> David A. Bandel
>
|
