X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 24725D1EEE3 for ; Tue, 20 Apr 2004 21:58:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94237-03 for ; Tue, 20 Apr 2004 21:57:59 -0300 (ADT) Received: from stubee.d2hosting.net (d2hosting.net [66.70.41.160]) by svr1.postgresql.org (Postfix) with ESMTP id E751ED1F71E for ; Tue, 20 Apr 2004 14:29:05 -0300 (ADT) Received: from idigx.com (stubee.d2hosting.net [66.70.41.160]) by stubee.d2hosting.net (8.11.6/linuxconf) with ESMTP id i3KHSvM20788; Tue, 20 Apr 2004 12:28:57 -0500 Message-ID: <40855DF0.3010300@idigx.com> Date: Tue, 20 Apr 2004 12:29:20 -0500 From: Thomas Swan User-Agent: Mozilla Thunderbird 0.6a (Windows/20040419) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Bruce Momjian Cc: Jeff Boes , PostgreSQL-development , matthew@zeut.net Subject: Re: pg_autovacuum crashes when query fails for temp tables References: <200404201525.i3KFPp809934@candle.pha.pa.us> In-Reply-To: <200404201525.i3KFPp809934@candle.pha.pa.us> X-Enigmail-Version: 0.83.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200404/593 X-Sequence-Number: 52515 Bruce Momjian wrote: >I looked into this and I see a number of cases where pg_autovacuum calls >send_query(), but doesn't test for a NULL return from the function. > >Matthew, would you look into this and submit a patch? Thanks. > > > Should pg_autovacuum be vacuuming temporary tables? Secondly, why would a temporary table for another session be visible to pg_autovacuum? I know these may sound like stupid questions, but I'm a little shocked that it found a temp table. Did someone make a permanent table, delete it, and pg_autovacuum found it in between those operations?