Bhushan Bhangale <bbhangale@Lastminute.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