7.1.1: pgdump fails

From: Peter Peltonen <peter(dot)peltonen(at)fivetec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.1.1: pgdump fails
Date: 2001-07-25 09:35:29
Message-ID: 3B5E92E1.4CA0485E@fivetec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm running postgresql 7.1.1 under redhat 7.1.

A few months ago I created a script that would run pgdump each night to dump
one db's data to a file. It worked then fine. Today I checked the file and
realised that it's size was 0 bytes. I then tried to run the pgdump command
myself and the result was this:

--snip--
[postgres(at)www postgres]$ pg_dump fivesync > db.test
getTables(): SELECT (for VIEW reportbudget_budgetcustprice) returned NULL oid
SELECT was: SELECT definition as viewdef, (select oid from pg_rewrite where
rulename='_RET' || viewname) as view_oid from pg_views where viewname =
'reportbudget_budgetcustprice';
--snip--

What does this mean and how do I fix my problem?

Regards,
Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juraj Petrik (Triblax) - work 2001-07-25 10:00:38 Compile problem on fBSD 4.3
Previous Message Richard Huxton 2001-07-25 08:56:35 Re: Inserts in triggers