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 Bhangale||Date: 2004-03-02 15:44:51|
|Subject: Re: calling function |
|Previous:||From: Bhushan Bhangale||Date: 2004-03-02 12:01:15|
|Subject: calling function|