function that rembers temple oid

From: "Michal Kochanowski" <michal(dot)kochanowski(at)pcguard(dot)pl>
To: "pgsql-novice-owner(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: function that rembers temple oid
Date: 2008-04-09 11:17:47
Message-ID: 3A5E0968A1C84FC4875F505308091923@HPCompaqPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I would like to use a temp table to store some calculations that i use later on.
The problem is that if i create such a table, drop it and then create it again during the same session the function is returning error cause it still rembers the oid of a first table that was created, it would work if i use an execute command , but execute cant be used in FOR select loop.

Any ideas?

Michal Kochanowski

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-04-09 14:43:53 Re: warnings restoring a db
Previous Message Matthew Pulis 2008-04-09 11:10:47 Re: Text Variable in a Function