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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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