Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: expected both swapped tables to have TOAST tables


  • From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
  • To: pgsql-general <pgsql-general(at)postgresql(dot)org>
  • Subject: Re: expected both swapped tables to have TOAST tables
  • Date: Tue, 31 Aug 2004 16:36:55 -0700
  • Message-id: <200408311636(dot)55598(dot)scrawford(at)pinpointresearch(dot)com>

On Tuesday 31 August 2004 3:52 pm, Tom Lane wrote:
> Steve Crawford <scrawford(at)pinpointresearch(dot)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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group