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

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: expected both swapped tables to have TOAST tables
  • Date: Tue, 31 Aug 2004 15:43:29 -0700
  • Message-id: <200408311543(dot)29828(dot)scrawford(at)pinpointresearch(dot)com>

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




Home | Main Index | Thread Index

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