> BTW, this is a pretty nasty error, although apparently infrequent give the
> lack of list e-mails. Can we fix it for 7.4 series?
Possibly, but I'm not very excited about it --- it's certainly a corner
case. I'm not sure it's worth the risk of breaking something.
rega
Tom,
> Yeah, I think you're stuck with doing that.
BTW, this is a pretty nasty error, although apparently infrequent give the
lack of list e-mails. Can we fix it for 7.4 series?
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)--
Josh Berkus <[EMAIL PROTECTED]> writes:
>> 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?
Yeah, I think you're stuck with doing that.
reg
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 tr
Josh Berkus <[EMAIL PROTECTED]> writes:
> 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 ...
regards, tom lane
--
Tom,
> > DBD::Pg::st execute failed: ERROR: expected both swapped tables to have
> > TOAST tables at sql_data_xfer.pl line 120, line 2.
>
> Have you done more to this table than TRUNCATE it?
>
> We recognized relatively recently that ALTER DROP COLUMN could drop the
> last/only variable-width co
Josh Berkus <[EMAIL PROTECTED]> writes:
> DBD::Pg::st execute failed: ERROR: expected both swapped tables to have TOAST
> tables at sql_data_xfer.pl line 120, line 2.
Have you done more to this table than TRUNCATE it?
We recognized relatively recently that ALTER DROP COLUMN could drop the
last
People,
Here's another:
Summary: TOAST error on frequently truncated tables
Version: 7.4.2
Severity: Abort
Platform: Red Hat 9.0
When running a script against a reporting database, I'm getting the following:
DBD::Pg::st execute failed: ERROR: expected both swapped tables to have TOAST
tables
