I found some subjects talking of my poblem but no real answer...

I'm trying to restore a database previously saved with the pg_dump command.
When trying to execute the pg_restore comand, I got the following error :

pg_restore: connecting to database for restore
pg_restore: dropping FK CONSTRAINT fk_xxxxxx
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3063; 2606 32970 FK CONSTRAINT

So it can't drop foreigne key constraints...
Later, I've got the following error:

pg_restore: dropping TABLE valeur_texte
pg_restore: [archiver (db)] Error from TOC entry 2128; 1259 31968 TABLE valeur_t
exte atih
pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table v
aleur_texte because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
Command was: DROP TABLE public.valeur_texte;
pg_restore: dropping TABLE valeur_reelle

It seems that my table can't be dropped because objects depending on it still exist... maybe the constraints that have not been dropped.
My problem is that if my table is not dropped, the data are still present, and the data of my dump will be inserted in it again...

The problem is that I don't know what happens because the dump and restore are made by postgre...

Can someone explain me what the problem is ?

Thanks a lot for your help

Messenger débarque dans Hotmail ! Essayez-le !

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
postedSep 9, '09 at 5:27p
activeSep 9, '09 at 5:27p

1 user in discussion

Sylvinhio sly: 1 post



site design / logo © 2022 Grokbase