[SQL] pg_dump error

Hi, I am using 8.2.1 on my dev server. When I do a pg_dump, I am getting an error message. pg_dump -U postgres podcast -t channel pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn How can I resolved this? What may be the problem? Because of this, I am no

[SQL] pg_dump error - Permission denied

Dear friends,   I am working with Postgres 7.3.4 on RH Linux 7.3.   I could manage to take a backup using the following command and as the user 'postgres'.  $ pg_dump -h 192.168.2.51 -v -u -f /home/db_repository/test20031103.sql test   But while I try to execute the same command with the user

[SQL] pg_dump error plus RelationBuildTriggers: 1 record(s) not found for rel links

Hi all, here is error I that am getting: pg_dump -s mondo > mondo.out PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 I faced similar example in the past too. At that time, there was a referentional constraint problem but this situation is different. I am usning postgres 7.0.3 on redh

Re: [SQL] pg_dump error - further information

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: > I would guess that this means there is a file named "pgdump_oid" hanging > around in the database directory, no doubt leftover from some previous > pg_dump cycle. Manually removing the file should get you up and running > again. However

Re: [SQL] pg_dump error

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: > Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Can not create pgdump_oid table. Explanation from backend: 'ERROR: > cannot create pgdump_oid > > Is there a way to repair this? > > I would guess that this means there is

Re: [SQL] pg_dump error

Tatsuo Ishii <[EMAIL PROTECTED]> writes: Can not create pgdump_oid table. Explanation from backend: 'ERROR: cannot create pgdump_oid Is there a way to repair this? I would guess that this means there is a file named "pgdump_oid" hanging around in the database directory, no d

Re: [SQL] pg_dump error

> >Can not create pgdump_oid table. Explanation from backend: 'ERROR: > >cannot create pgdump_oid > > > >Is there a way to repair this? > > > > If there was an earlier crash while running pg_dump, the table may already > exist. If so, try deleting it. Also, can you confirm that the username > un

Re: [SQL] pg_dump error

At 22:13 15/01/01 +0200, Johann Spies wrote: > >Can not create pgdump_oid table. Explanation from backend: 'ERROR: >cannot create pgdump_oid > >Is there a way to repair this? > If there was an earlier crash while running pg_dump, the table may already exist. If so, try deleting it. Also, can you

[SQL] pg_dump error

Version 6.5.3 on Debian Potato My daily cron job reported : Can not create pgdump_oid table. Explanation from backend: 'ERROR: cannot create pgdump_oid Is there a way to repair this? Johann -- J.H. Spies - Tel. 082 782 0336 "For I know that my redeemer liveth, and that he shall

Re: [SQL] pg_dump Error

Najm Hashmi <[EMAIL PROTECTED]> writes: > while trying to dump db shcema and content, I am getting the > following error: > [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql > PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 > Segmentation fault (core dumped) Hmm, look

[SQL] pg_dump Error

Hi all, while trying to dump db shcema and content, I am getting the following error: [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 Segmentation fault (core dumped) Any suggestion what I am doing wrong and why i am