The following bug has been logged online:

Bug reference: 2853
Logged by: Terry Askew
Email address: taskew@demandforesight.com
PostgreSQL version: 8.1.5
Operating system: Windows Server 2000
Description: Internal error XXOO Hangs while attempting to clear
table after several successful iterations
Details:

Batch Process completes, then Data Profiles creation is attempted, but
stalls after several Profiles create. To create the next profile,we require
a data dump of the current table in memory just created, so that as the
profiles are being created on the fly, the table acts as a tempTable.

This is the only technical issue left to resolve so that the LIVE system can
be used and accepted by our users.

Pls Help.

Sincerely,
Terry Askew
Executive VP, Software Development
Foresight Technologies, LLC.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

upgrade to 8.2.0
that problem was fixed there (had it myself as well)

- thomas

----- Original Message -----
From: "Terry Askew" <taskew@demandforesight.com>
To: <pgsql-bugs@postgresql.org>
Sent: Thursday, December 21, 2006 6:13 PM
Subject: [BUGS] BUG #2853: Internal error XXOO Hangs while attempting to
clear table after several successful iterations


>
> The following bug has been logged online:
>
> Bug reference: 2853
> Logged by: Terry Askew
> Email address: taskew@demandforesight.com
> PostgreSQL version: 8.1.5
> Operating system: Windows Server 2000
> Description: Internal error XXOO Hangs while attempting to clear
> table after several successful iterations
> Details:
>
> Batch Process completes, then Data Profiles creation is attempted, but
> stalls after several Profiles create. To create the next profile,we
> require
> a data dump of the current table in memory just created, so that as the
> profiles are being created on the fly, the table acts as a tempTable.
>
> This is the only technical issue left to resolve so that the LIVE system
> can
> be used and accepted by our users.
>
> Pls Help.
>
> Sincerely,
> Terry Askew
> Executive VP, Software Development
> Foresight Technologies, LLC.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend