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
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
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
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
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
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
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