expected both swapped tables to have TOAST tables

[Steve Crawford]

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('sec ond'::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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Steve Crawford <sc*******@pinp ointresearch.co m> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Steve Crawford]

On Tuesday 31 August 2004 3:52 pm, Tom Lane wrote:

Steve Crawford <sc*******@pinp ointresearch.co m> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly