problem with pg_dump

From: mat(at)reynerie(dot)yi(dot)org
To: pgsql-novice(at)postgresql(dot)org
Subject: problem with pg_dump
Date: 2001-01-12 15:35:42
Message-ID: 20010112163542.A21793@po.reynerie.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-12 16:00:35 Re: Pg subtracts one minute from time
Previous Message Neil Ernstzen 2001-01-12 14:42:19 Creating tables from VB