From: | mike <mike(at)redtux1(dot)uklinux(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem restoring Database |
Date: | 2004-04-01 15:56:38 |
Message-ID: | 1080834998.1610.10.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have just upgraded froom Fedora test1 to test2 which has upgraded
postgres version from 7.4.2 to 7.4.5 (frrom rpm -q)
I have used pg_dumpall to dump my database, the restore appeared to go
OK, except there is no data in two of my tables (only these two)
output from \d \d tb_invoice_header
Table
"public.tb_invoice_header"
Column | Type
| Modifiers
--------------------+-----------------------+-----------------------------------------------------------------------
inv_id | integer | not null default
nextval('public.tb_invoice_header_inv_id_seq'::text)
client_id | integer |
payable_recievable | character varying(15) |
amount | money |
amount_paid | money |
date_paid | date |
cheque | character varying(20) |
Indexes:
"ih_pk" primary key, btree (inv_id)
\d tb_invoice_detail
Table "public.tb_invoice_detail"
Column | Type |
Modifiers
-------------+------------------------+-------------------------------------------------------------------
id | integer | not null default
nextval('public.tb_invoice_detail_id_seq'::text)
invoice_id | integer |
code | character varying(15) |
description | character varying(100) |
amount | money |
vat_code | smallint |
line_total | money |
Indexes:
"tb_id_pk" primary key, btree (id)
Foreign-key constraints:
"$1" FOREIGN KEY (invoice_id) REFERENCES tb_invoice_header(inv_id)
The dump file contains all the data
Anyone have any idea what is happening, and more important how to rescue
thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Barr | 2004-04-01 16:29:29 | Re: Select Union |
Previous Message | Randall Skelton | 2004-04-01 15:56:03 | Select Union |