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

Re: calling function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bhushan Bhangale <bbhangale(at)Lastminute(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: calling function
Date: 2004-03-02 15:15:52
Message-ID: 27578.1078240552@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Bhushan Bhangale <bbhangale(at)Lastminute(dot)com> writes:
> Error: ERROR:  relation with OID 659490 does not exist (State:S1000, Native
> Code: 7)

That function is only going to work once per session, because plpgsql
caches query plans.  After the first call, the commands in the loop will
refer to a version of temp_accomm that doesn't exist anymore.

AFAICS you do not actually need the temp_accum table anyway.  Why don't
you just return the data directly from the main loop?

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Bhushan BhangaleDate: 2004-03-02 15:44:51
Subject: Re: calling function
Previous:From: Bhushan BhangaleDate: 2004-03-02 12:01:15
Subject: calling function

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