[BUGS] BUG #2853: Internal error XXOO Hangs while attempting to clear table after several successful iterations

2006-12-21 Thread Terry Askew

The following bug has been logged online:

Bug reference:  2853
Logged by:  Terry Askew
Email address:  [EMAIL PROTECTED]
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


Re: [BUGS] BUG #2853: Internal error XXOO Hangs while attempting to clear table after several successful iterations

2006-12-21 Thread Thomas H.

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

- thomas

- Original Message - 
From: Terry Askew [EMAIL PROTECTED]

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:  [EMAIL PROTECTED]
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