Problem restoring Database
От | mike |
---|---|
Тема | Problem restoring Database |
Дата | |
Msg-id | 1080834998.1610.10.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Problem restoring Database
Re: Problem restoring Database |
Список | 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
В списке pgsql-general по дате отправления: