[HACKERS] autovacuum: found orphan temp table

2014-07-02 Thread Joshua D. Drake
Hello, While it is obvious what is happening in $SUBJECT as well as reasonably obvious why it can happen. What isn't obvious is what to do about it. It seems we log in as a super user and drop the temp tables. However, I would think if we know that it is orphaned that autovacuum should

Re: [HACKERS] autovacuum: found orphan temp table

2014-07-02 Thread Alvaro Herrera
Joshua D. Drake wrote: Hi, While it is obvious what is happening in $SUBJECT as well as reasonably obvious why it can happen. What isn't obvious is what to do about it. It seems we log in as a super user and drop the temp tables. However, I would think if we know that it is orphaned that

Re: [HACKERS] autovacuum: found orphan temp table

2014-07-02 Thread Tom Lane
Joshua D. Drake j...@commandprompt.com writes: While it is obvious what is happening in $SUBJECT as well as reasonably obvious why it can happen. What isn't obvious is what to do about it. It seems we log in as a super user and drop the temp tables. You don't need to do anything --- the