Thread: pg_dump

pg_dump

From
"raymund"
Date:

 

Hello,

 

I was trying to backup my database in postgresql 7.1 using “pg_dump mbs > mbs.bu”.  But I encountered an error:

 

getTables(): Select (funcname) for trigger reg_lock returned 0 tuples. Expected 1. 

 

Is there something wrong with the trigger I made in the database?  I am using plpgsql on my database script. 

 

Thanks…

 

raymund

Re: pg_dump

From
"Dave Cramer"
Date:
Raymund,
 
I would have to see the trigger code to see what is going on.
 
You may have better luck posting this to pgsql-general
 
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of raymund
Sent: Wednesday, January 30, 2002 1:28 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] pg_dump

 

Hello,

 

I was trying to backup my database in postgresql 7.1 using “pg_dump mbs > mbs.bu”.  But I encountered an error:

 

getTables(): Select (funcname) for trigger reg_lock returned 0 tuples. Expected 1. 

 

Is there something wrong with the trigger I made in the database?  I am using plpgsql on my database script. 

 

Thanks…

 

raymund

Re: pg_dump

From
Justin Clift
Date:
Hi Raymund,

Someone else had a problem like this ages ago.  I think it was caused by
a version mismatch between pg_dump and the running database.

Is there any change the version of pg_dump you're using is accidentally
from a different release of PostgreSQL and getting in the path somehow?

btw, which O/S are you on?

:-)

Regards and best wishes,

Justin Clift


-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of raymund
Sent: Wednesday, January 30, 2002 1:28 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] pg_dump



Hello,

I was trying to backup my database in postgresql 7.1 using "pg_dump mbs
> mbs.bu".  But I encountered an error:

getTables(): Select (funcname) for trigger reg_lock returned 0 tuples.
Expected 1.

Is there something wrong with the trigger I made in the database?  I am
using plpgsql on my database script.

Thanks.

raymund
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi