Re: pg_class.relistemp

On 14.07.2011 19:51, David E. Wheeler wrote:
> On Jul 13, 2011, at 12:57 PM, Kevin Grittner wrote:
>
>> create or replace function relistemp(rel pg_class)
>>   returns boolean language sql immutable strict as
>>   $$select $1.relpersistence = 't';$$;
>>
>> Just don't forget to use the table name or alias in front of it... :-)
>
> Oh, nice hack. How far back does that work (pgTAP runs on 8.0 and higher)?

Far back. But you only need it in >= 9.1. Older versions have the 
pg_class.relistemp column anyway.

Not sure how this helps, though. If you modify pgTAP to install that 
automatically in pgTAP when dealing with a new server version, you might 
as well modify its queries to use relispersistence = 't' directly when 
dealing with a new server version. It works as a manual work-around if 
you can't upgrade pgTAP, I guess.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com