Re: pg_autovacuum crashes when query fails for temp - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_autovacuum crashes when query fails for temp
Date
Msg-id 408603D7.5080505@familyhealth.com.au
Whole thread Raw
In response to Re: pg_autovacuum crashes when query fails for temp  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
> Ok, so I will change pg_autovacuum to explicitly ignore temp tables.  
> Just to be sure, I can do this by avoiding anything found in the pg_temp 
> schemea, or is there a better way?  Is it possible that a user could or 
> would put a non-temp table the pg_temp schemea?

There's no such thing as the pg_temp schema, you will get lots of 
pg_temp_xxx schemas I think.

Chris



pgsql-hackers by date:

Previous
From: mike g
Date:
Subject: Duplicate variable declared?
Next
From: Joe Conway
Date:
Subject: Re: Duplicate variable declared?