i forgot to attach the error messages. but now!
t
On 7/16/05, Thomas Chille <thomas.chille@xxxxxxxxx> wrote:
> Hi!
>
> I dumped from a 7.3.4 server on debian with kernel 2.6 using this command:
>
> pg_dump -F c -Z 9 -f backoffice.dmp.c backoffice
>
>
> I tried to restore on a similiar system using:
>
> pg_restore -vd backoffice backoffice.dmp.c
>
>
> and stepped into an error:
>
> ERROR: copy: line 270892, Missing data for column "id_tax"
> ..
> FATAL: Socket command type 3 unknown
>
> more detailed messages are attached.
>
>
> could somebody help me please fixing this problem?
>
> thanks in advance
> thomas
>
client message:
...
pg_restore: restoring data for table tmp_order_data
pg_restore: [archiver (db)] error returned by PQputline
pg_restore: *** aborted because of error
server mesage (log):
...
2005-07-16 15:42:25 [17889] DEBUG: StartTransactionCommand
2005-07-16 15:42:25 [17889] LOG: query:
2005-07-16 15:42:25 [17889] DEBUG: ProcessUtility
2005-07-16 15:42:34 [17889] ERROR: copy: line 270892, Missing data for column "id_tax"
2005-07-16 15:42:34 [17889] LOG: statement:
--
-- Data for TOC entry 1754 (OID 1285883)
-- Name: tmp_order_data; Type: TABLE DATA; Schema: public; Owner: postgres
-- Data Pos: 9733254
--
COPY tmp_order_data (ss_id_transaction, ssd_transaction, id_transactiontype, business_day, transactiontime, id_company, id_operator, id_dining, id_sold_item, id_pos, id_pos_item, selling_price, quantity, id_invoice, invoice_number, reason, discount, id_tax, standard_price, id_dining_dest, id_pos_dest, id_invoice_dest, operator_name, item_name, plu, is_flow_item, pos_name, commodity_name, splitcode, id_sold_item_dest, id_sold_item_remain, state, processed, replication_id, id_price_level, id_gift_settle_cat, quantity_remain) FROM stdin;
2005-07-16 15:42:34 [17889] DEBUG: AbortCurrentTransaction
2005-07-16 15:42:34 [17889] FATAL: Socket command type 3 unknown
2005-07-16 15:42:34 [17889] DEBUG: proc_exit(0)
2005-07-16 15:42:34 [17889] DEBUG: shmem_exit(0)
2005-07-16 15:42:34 [17889] DEBUG: exit(0)
2005-07-16 15:42:34 [17771] DEBUG: child process (pid 17889) exited with exit code 0
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
