Re: [SQL] pg_dump error - further information

2001-01-16 Thread Johann Spies
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

2001-01-16 Thread Johann Spies
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

2001-01-15 Thread Tom Lane
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

2001-01-15 Thread Tatsuo Ishii
> >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

2001-01-15 Thread Philip Warner
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

Re: [SQL] pg_dump Error

2000-12-22 Thread Tom Lane
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