<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=951243304-16032005>Hi
strk,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=951243304-16032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=951243304-16032005>I have defiantly
found a leak this time :-) in that if I run the following query I get out of
memory error, and also watching the postgresql process on the box shows the
memory consumption continually increasing over time, whilst the query is
running.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=951243304-16032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=951243304-16032005>SELECT
crs_feature_name.id, crs_feature_name."type", crs_feature_name.name,
crs_feature_name.status, crs_feature_name.other_details,
astext(translate(crs_feature_name.shape, 160, 0, 0)) AS shape<BR>FROM
crs_feature_name<BR>inner join crs_parcel on crs_feature_name.id =
crs_parcel.fen_id<BR>limit 100;</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=951243304-16032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=951243304-16032005>Translate seems
to work fine if it's used on its own, but when combining with astext or
transform then this is the output (from astext combination
anyway).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=951243304-16032005></SPAN></FONT><FONT
face=Arial size=2><SPAN class=951243304-16032005>ERROR: out of
memory<BR>DETAIL: Failed on request of size
268435456.<BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial size=2><SPAN class=951243304-16032005>This has only shown
up since RC2 as far as I can tell.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=951243304-16032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=951243304-16032005>Cheers,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=951243304-16032005>Bryce.</SPAN></FONT></DIV></BODY></HTML>