Re: cannot reach http:/archives.postgresql.org

we hope to have archives back up later on tonight ...

On Tue, 31 Aug 2004, Ennio-Sr wrote:

> * Ennio-Sr <nasr(dot)laili(at)tin(dot)it> [310804, 16:08]:
>> Is that site working for you?
>> I'm unable to reach it since a couple of days, my messages are not
>> getting through, pgsql-?????-owner(at)postgresql(dot)org do not answer my
>> 'requests for clarification', majordomo is not responding to my
>> 'archive-get'
> [cut]
>
> Thanks to David and Jeff for assuring me that I'm not the only one facing
> a connection problem, and to Ron, for suggesting an alternative (I could
> see some of my posts but was unable to get the relative threads).
> At the end I got these posts via an archive-get command (which was
> unsuccessfull for past attempts!).
> http://archives.postgresql.org is still down and I suspect they are also
> experiencing other problems (my posts to pgsql-cygwin are still nowhere
> to be seen).
> As a measure of last resort I'll try to unsubscribe from that list and
> re-subscribe ... :-)
>
> Many thanks again to all of you.
> Cheers,
> Ennio.
>
>
>
> --
> [Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
> Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
> [Why to use Win$ozz (I say) if ... "even a fool can do that. )=(
> Do something you aren't good at!" (used to say Henry Miller) ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>From pgsql-general-owner(at)postgresql(dot)org Tue Aug 31 19:43:34 2004
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id CAB775E4721
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Tue, 31 Aug 2004 19:43:32 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 97486-02
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Tue, 31 Aug 2004 22:43:28 +0000 (GMT)
Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130])
by svr1.postgresql.org (Postfix) with ESMTP id 822B25E471F
for <pgsql-general(at)postgresql(dot)org>; Tue, 31 Aug 2004 19:43:26 -0300 (ADT)
Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179])
by polaris.pinpointresearch.com (Postfix) with ESMTP id 0F2A51045E
for <pgsql-general(at)postgresql(dot)org>; Tue, 31 Aug 2004 15:43:30 -0700 (PDT)
From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Organization: Pinpoint Research
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
User-Agent: KMail/1.5.1
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200408311543(dot)29828(dot)scrawford(at)pinpointresearch(dot)com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 testsX-Spam-Level:
X-Archive-Number: 200408/1639
X-Sequence-Number: 65194

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