Re: expected both swapped tables to have TOAST tables

Started by Tom Laneover 21 years ago2 messagesgeneral
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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

#2Steve Crawford
scrawford@pinpointresearch.com
In reply to: Tom Lane (#1)

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