Re: expected both swapped tables to have TOAST tables - Mailing list pgsql-general

From Steve Crawford
Subject Re: expected both swapped tables to have TOAST tables
Date
Msg-id 200408311636.55598.scrawford@pinpointresearch.com
Whole thread Raw
In response to Re: expected both swapped tables to have TOAST tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Ennio-Sr
Date:
Subject: Re: [OT?] Problems with majordomo :-)
Next
From: Steve Crawford
Date:
Subject: Re: Multicolumn Primary Key