Re: pg_class.relistemp

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_class.relistemp
Date: 2011-07-14 16:51:10
Message-ID: C57198A6-E8D8-4711-B821-8984A733EF47@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)?

Thanks,

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2011-07-14 16:53:08 Re: Full GUID support
Previous Message Heikki Linnakangas 2011-07-14 16:43:39 Re: Single pass vacuum - take 1