Обсуждение: problem with pg_dump

Поиск
Список
Период
Сортировка

problem with pg_dump

От
mat@reynerie.yi.org
Дата:
hi, i'm trying to dump a database with the command :

pg_dump -u -d -f ledump  -h localhost zeturf

but pg_dump failed with this message :

getTables(): relation 'robe': cannot find function with oid 1654 for trigger RI_ConstraintTrigger_76643

i've tried to pass differrents options to pg_dump :
-d for dump insert
-D for dump with insert and attributes names
-a for dump only the data
-s for dump only the structure

i've got also a NOTICE message :
NOTICE:  Unrecognized variable client_encoding

but i read in user manual that it is 'harmless'.

i'm using postgresql 7.0.3 under Debian Linux (latest)

could anyone help me ?

thanks

mat