Terry Chong <198back(at)gmail(dot)com> writes:
> My question is that if we detect an error at line 15 and we get into the
> ereport code, would the memory allocated under multi_call_memory_ctx gets
> cleaned up properly?
Yes, it would. That's just the executor's query context, or maybe a
subcontext thereof, so it'll go away when the query is abandoned.
By and large, functions following ordinary coding conventions don't need
to worry about resource cleanup on error. The exception would be if you
were holding open file descriptors or some such that the core system
didn't know about.
regards, tom lane