> Now, I updated the database installation to the last 6.5 release,
> hoping that it would fixed the bugs but no. The same thing
> happen except now that other query to the used-to-be-locked table
> now complete (thanks to the new MVCC!) Also it is now pg_temp.XXXXX
> files which are eating all the space.
>
> This is what I know from the client web application. They are
> using Perl/DBI. Their code is messy. There are problems
> with their SQL. ( I see parse errors in the logs and things
> like that) They are not using transaction.
They are performing sorts that perhaps are failing. BTW, the files will
be called pg_sorttemp in 6.5.1.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
