Обсуждение: expected both swapped tables to have TOAST tables

I tried to truncate a table and received the following error:
"expected both swapped tables to have TOAST tables".

Googling provided no insight. What does it mean?

Version 7.4.1.

Note: I can delete from the table and vacuum full to empty it, I just
can't truncate it. I don't see anything special with this table and
can truncate a nearly identical one. Here's the structure:

Table "foobar"
 Column |           Type           |                 Modifiers
--------+--------------------------+-------------------------------------------
 asof   | timestamp with time zone | default
date_trunc('second'::text, now())
 r0     | smallint                 |
 r1     | character varying(30)    |
 r2     | character varying(30)    |
 r3     | character varying(30)    |
 r4     | character varying(30)    |
 r5     | character varying(30)    |
 r6     | character varying(30)    |

Cheers,
Steve

Steve Crawford <scrawford@pinpointresearch.com> writes:
> I tried to truncate a table and received the following error:
> "expected both swapped tables to have TOAST tables".
> Googling provided no insight. What does it mean?

It's a bug.  You probably dropped the last toastable column from
the table.

            regards, tom lane

On Tuesday 31 August 2004 3:52 pm, Tom Lane wrote:
> Steve Crawford <scrawford@pinpointresearch.com> writes:
> > I tried to truncate a table and received the following error:
> > "expected both swapped tables to have TOAST tables".
> > Googling provided no insight. What does it mean?
>
> It's a bug.  You probably dropped the last toastable column from
> the table.

Thanks. This table was created from another table as a "create table
foo as select * from bar limit 0" followed by an "alter table foo
drop column lastcolumn" so that would make sense.

As long as this isn't indicitave of future problems with this table I
won't worry as it is only being used for a couple weeks for debugging
and will only have inserts from here on out.

Cheers,
Steve