Re: TOAST error in 7.4.2 on frequently truncated tables - Mailing list pgsql-bugs

From Josh Berkus
Subject Re: TOAST error in 7.4.2 on frequently truncated tables
Date
Msg-id 200408251000.12719.josh@agliodbs.com
Whole thread Raw
In response to Re: TOAST error in 7.4.2 on frequently truncated tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TOAST error in 7.4.2 on frequently truncated tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom,

> > Aha!  Yes, the problem is that I dropped the last VARCHAR column, not in
> > that table but in one that came after it.   Any workaround to fix?
>
> Easiest is to add back a useless varchar column ...

Can't do it, the column needed to be dropped in order to fix a problem with
the data transfer.    Maybe re-create the table?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: TOAST error in 7.4.2 on frequently truncated tables
Next
From: Tom Lane
Date:
Subject: Re: TOAST error in 7.4.2 on frequently truncated tables