Re: postgresql locks the whole table!

On Fri, 5 Dec 2003, Jason C. Pion wrote:

> On Thu, 4 Dec 2003, Alvar Freude wrote:
>
> > > Help!
> >
> > you may look in the archives; one day ago there was the same question.
> >
>
> Actually, this _is_ the question from a few days ago. A quick look at the
> message headers shows that the message was held up for a couple of days by
> one of the mailing list's servers.
>
> Received: from svr1.postgresql.org ([200.46.204.71] helo=postgresql.org)
> by noon.pghoster.com with esmtp (Exim 4.24)
> id 1AS0DB-0005f7-Td
> for jpion(at)valhalla(dot)homelinux(dot)org; Thu, 04 Dec 2003 14:36:34 -0600
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
> Received: from localhost (neptune.hub.org [200.46.204.2])
> by svr1.postgresql.org (Postfix) with ESMTP id 21F63D1B4D6
> for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Tue,
> 2 Dec 2003 23:02:52 +0000 (GMT)
> ^^^^^^^^^^^^^^^^^^^^^^^^^
>
> I've noticed a fair bit of mail coming in where the answer shows up even
> before the question does. Are there problems with the mail servers?

It was probably originally sent from an unsubscribed account which meant
it got put into the moderator queue. The user probably subscribed upon
receipt of the message that it was being held and resent the message.