Temp tables in Postgresql.

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #267,335 by mmoffitt 9/12/06 2:04:10 PM Reply	Temp tables in Postgresql. We have a C# app executing a postgresql/edb function that returns a refcursor from a temp table. We're getting the following error: ERROR: 42P01: relation with OID 92499 does not exist EnterpriseDB.EDBClient.EDBException: relation with OID 92499 does not exist This function is a longish one and the problem, I think, is that edb/postgresql is caching the function with the OID's of the temp tables from a prior call (that don't exist anymore). Anyone got any idears how to get around this? TIA! bcnu, Mikem It would seem, therefore, that the three human impulses embodied in religion are fear, conceit, and hatred. The purpose of religion, one might say, is to give an air of respectibility to these passions. -- Bertrand Russell
Post #267,349 by drewk 9/12/06 2:44:26 PM Reply	Can't you specify nocache on the sproc? === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #267,925 by mmoffitt 9/18/06 11:46:47 AM Reply	Thanks, Drew. Sorry I didn't post before, I had my head down working on a work-around that, for now at least, will work. Been too long since I used postgresql and I'm gonna hafta get better at it. Had my head in Sql Server and DB2 UDB for a bunch of years now. bcnu, Mikem It would seem, therefore, that the three human impulses embodied in religion are fear, conceit, and hatred. The purpose of religion, one might say, is to give an air of respectibility to these passions. -- Bertrand Russell
Post #267,951 by jake123 9/18/06 12:36:37 PM Reply	I thot it was s'posed to be the gigglecache on the haverproc or maybe it was the hemoselect? --\n-------------------------------------------------------------------\n* Jack Troughton jake at consultron.ca \n [link\|http://consultron.ca\|http://consultron.ca] [link\|irc://irc.ecomstation.ca\|irc://irc.ecomstation.ca] \n Kingston Ontario Canada [link\|news://news.consultron.ca\|news://news.consultron.ca] *\n-------------------------------------------------------------------

Temp tables in Postgresql. - (mmoffitt) - (3) - Sept. 12, 2006, 02:04:10 PM EDT

Can't you specify nocache on the sproc? -NT - (drewk) - (2) - Sept. 12, 2006, 02:44:26 PM EDT

Thanks, Drew. - (mmoffitt) - (1) - Sept. 18, 2006, 11:46:47 AM EDT

I thot it was s'posed to be the gigglecache on the haverproc - (jake123) - Sept. 18, 2006, 12:36:37 PM EDT

iwethey.org

We've spent the past two years building up an immunity to Iocaine!
80 ms