On Fri, Jan 09, 2004 at 12:07:25PM -0800, Kragen Sitaker wrote: <snip>
Not really related to your problem, but given you're in a transaction, why do you need to lock anything? What's wrong with: > The daemon that gets this error does the following every 15 seconds: > - start a transaction > - delete the contents of the other table > - execute a complex and sometimes slow SELECT INTO query, creating a > temporary table > - copy the contents of the temporary table into the other table > - drop the temporary table (again, embarrassing, sorry) > - commit Maybe I'm missing something? -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > (... have gone from d-i being barely usable even by its developers > anywhere, to being about 20% done. Sweet. And the last 80% usually takes > 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce
pgp00000.pgp
Description: PGP signature