Do TEMP Tables have an OID? Can this be a problem if used too frequently?

From: Phil Couling <couling(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Do TEMP Tables have an OID? Can this be a problem if used too frequently?
Date: 2009-04-30 09:01:14
Message-ID: 49F968DA.2010507@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
I've just written a search function which creates a temp table, preforms
some reasoning on it returning results then drops it again.
I'm using temp tables in an attempt to gain efficiency (not repeating
work between one section of the function and another).

However I'm worried that there may be some pit falls in doing this. I'm
especially worried about OIDs.

Does creating a temp table assign an OID to the table?
If so am I right to assume that, if the function is used too frequently,
it could cause the database to crash by wraping OIDs?

Thanks very much for your time
Phil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2009-04-30 10:03:10 Re: triggers and execute...
Previous Message Craig Ringer 2009-04-30 08:54:08 Mapping output from a SEQUENCE into something non-repeating/colliding but random-looking?