Re: memory leak while using cursors - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org writes:
> memory leak while using cursors

> DECLARE BOB CURSOR FOR select date_part('epoch', call_time), date_part('hour', call_time), date_part('minute',
call_time),date_part('dow', call_time), * from call_jan where call_time >= '2000/12/16 00:00:00.000' and call_time <
'2001/01/2100:00:00.000'  FOR READ ONLY; 

The date_part function calls will each leak a few bytes of memory that
doesn't get reclaimed till end of query (= cursor close, in this case).
This is fixed for 7.1 but there's no fix for older versions.

            regards, tom lane