Do TEMP Tables have an OID? Can this be a problem if used too frequently? - Mailing list pgsql-general

From Phil Couling
Subject Do TEMP Tables have an OID? Can this be a problem if used too frequently?
Date
Msg-id 49F968DA.2010507@gmail.com
Whole thread Raw
Responses Re: Do TEMP Tables have an OID? Can this be a problem if used too frequently?  (Raymond O'Donnell <rod@iol.ie>)
List 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

pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Two Questions Re: Warm Backup
Next
From: Scott Marlowe
Date:
Subject: Re: triggers and execute...