Heikki Linnakangas <[EMAIL PROTECTED]> writes: > LOG: autovacuum: found orphan temp table "pg_temp_2"."foo" in database > "postgres"
> I remember the discussion when that was put in, but I'm starting to > think that printing that every time autovacuum wakes up, which is once > per minute by default, is too noisy. What else would you do? I can't see adding state to remember when we printed it last. > Also, it doesn't give me any hint > on what I can do to get rid of the message; I had to search the archives > to find out that I can "DROP SCHEMA pg_temp_2". We could surely add an errhint() to the message. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers