Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group