RE: [GENERAL] Error during 'vacuum analyze'

1999-08-20 Thread G. Anthony Reina
Mark, The error you are experiencing was discussed on the hacker's list last week. Oliver Elphick and Tom Good worked out a patch for SQL to solve the problem. You're right that the pg_vlock is getting created and then getting deleted during the vacuuming of the last table. This ends up boink

[GENERAL] Error during 'vacuum analyze'

1999-08-19 Thread Mark Dalphin
Hi, Running PostgreSQL 6.5.1 on SGI Irix 6.5. When I ran vacuum analyze over my database, I had an unexpected error occur: htg=> vacuum analyze; NOTICE: AbortTransaction and not in in-progress state pqReadData() -- backend closed the channel unexpectedly. This probably means the backen