[EMAIL PROTECTED] 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/21
>00: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
