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

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

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
Cc: pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: cannot reach http:/archives.postgresql.org
Date: 2004-08-31 22:24:42
Message-ID: 20040831192419.U31538@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

pgsql-general by date

Next:From: Matthew T. O'ConnorDate: 2004-08-31 22:49:52
Subject: Re: Multicolumn Primary Key
Previous:From: Joe ConwayDate: 2004-08-31 22:07:49
Subject: Re: Large Databases

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