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

Re: TOAST error in 7.4.2 on frequently truncated tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: TOAST error in 7.4.2 on frequently truncated tables
Date: 2004-08-25 17:00:12
Message-ID: 200408251000.12719.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom,

> > Aha!  Yes, the problem is that I dropped the last VARCHAR column, not in
> > that table but in one that came after it.   Any workaround to fix?
>
> Easiest is to add back a useless varchar column ...

Can't do it, the column needed to be dropped in order to fix a problem with 
the data transfer.    Maybe re-create the table?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-08-25 17:06:17
Subject: Re: TOAST error in 7.4.2 on frequently truncated tables
Previous:From: ffffceffffac ffffbdffffaaDate: 2004-08-25 11:47:08
Subject: Re: server crash in very big transaction [postgresql 8.0beta1]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group