Re: [GENERAL] Fixing up a corrupted toast table

2006-03-09 Thread Marko Kreen
On 3/9/06, Tom Lane <[EMAIL PROTECTED]> wrote: > Steve Atkins <[EMAIL PROTECTED]> writes: > >>> make it happy by inserting a dummy row into the toast table (chunk ID > >>> as specified in the error, chunk sequence 0, any old data value). > > > Any attempt to touch the toast table gives me: > > ERRO

Re: [GENERAL] Fixing up a corrupted toast table

2006-03-08 Thread Steve Atkins
On Mar 8, 2006, at 3:07 PM, Tom Lane wrote: Steve Atkins <[EMAIL PROTECTED]> writes: make it happy by inserting a dummy row into the toast table (chunk ID as specified in the error, chunk sequence 0, any old data value). Any attempt to touch the toast table gives me: ERROR: cannot change

Re: [GENERAL] Fixing up a corrupted toast table

2006-03-08 Thread Tom Lane
Steve Atkins <[EMAIL PROTECTED]> writes: >>> make it happy by inserting a dummy row into the toast table (chunk ID >>> as specified in the error, chunk sequence 0, any old data value). > Any attempt to touch the toast table gives me: > ERROR: cannot change TOAST relation "pg_toast_17410" Ugh. M

Re: [GENERAL] Fixing up a corrupted toast table

2006-03-08 Thread Steve Atkins
On Feb 17, 2006, at 8:27 AM, Steve Atkins wrote: On Feb 17, 2006, at 6:29 AM, Tom Lane wrote: Steve Atkins <[EMAIL PROTECTED]> writes: pg_dump: ERROR: missing chunk number 0 for toast value 25923965 [snip] If that doesn't work, the standard technique for locating damaged data should

Re: [GENERAL] Fixing up a corrupted toast table

2006-02-17 Thread Steve Atkins
On Feb 17, 2006, at 6:29 AM, Tom Lane wrote: Steve Atkins <[EMAIL PROTECTED]> writes: pg_dump: ERROR: missing chunk number 0 for toast value 25923965 I'd like to make the current problem go away, though, perhaps by deleting the relevant row in the element table. I'm not quite sure how to

Re: [GENERAL] Fixing up a corrupted toast table

2006-02-17 Thread Tom Lane
Steve Atkins <[EMAIL PROTECTED]> writes: > pg_dump: ERROR: missing chunk number 0 for toast value 25923965 > I'd like to make the current problem go away, though, perhaps by > deleting the relevant row in the element table. I'm not quite sure how > to go about that, though. Could anyone point me

[GENERAL] Fixing up a corrupted toast table

2006-02-16 Thread Steve Atkins
I have an older 7.4 installation which is giving this error during pg_dump: pg_dump: ERROR: missing chunk number 0 for toast value 25923965 pg_dump: SQL command to dump the contents of table "element" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: missing chunk number 0