<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body><FONT size=2>
Hello,<BR>
I have a problem when I run st_endpoint function : the query kill the process.<BR>
The same query with st_startpoint works fine. I'm also able to run st_endpoint with postgis 1.2.1 with no problem.<BR>
My conf <BR>
Windows XP<BR>
"PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)"<BR>
"POSTGIS="1.3.1" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS"<BR>
The log<BR>
2007-08-21 23:11:04 STATEMENT: select y(st _endpoint(the_geom)) from streets limit 10<BR>
2007-08-21 23:11:16 LOG: server process (PID 4988) exited with exit code -1073741819<BR>
2007-08-21 23:11:16 LOG: terminating any other active server processes<BR>
2007-08-21 23:11:16 WARNING: terminating connection because of crash of another server process<BR>
2007-08-21 23:11:16 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<BR>
2007-08-21 23:11:16 HINT: In a moment you should be able to reconnect to the database and repeat your command.<BR>
2007-08-21 23:11:16 WARNING: terminating connection because of crash of another server process<BR>
2007-08-21 23:11:16 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<BR>
2007-08-21 23:11:16 HINT: In a moment you should be able to reconnect to the database and repeat your command.<BR>
2007-08-21 23:11:16 LOG: all server processes terminated; reinitializing<BR>
2007-08-21 23:11:16 LOG: database system was interrupted at 2007-08-21 23:09:07 Paris, Madrid<BR>
2007-08-21 23:11:16 LOG: checkpoint record is at 5/D3ECC1D0<BR>
2007-08-21 23:11:16 LOG: redo record is at 5/D3ECC1D0; undo record is at 0/0; shutdown FALSE<BR>
2007-08-21 23:11:16 LOG: next transaction ID: 0/1226346; next OID: 101454<BR>
2007-08-21 23:11:16 LOG: next MultiXactId: 1; next MultiXactOffset: 0<BR>
2007-08-21 23:11:16 LOG: database system was not properly shut down; automatic recovery in progress<BR>
2007-08-21 23:11:16 LOG: redo starts at 5/D3ECC220<BR>
2007-08-21 23:11:16 LOG: record with zero length at 5/D42FAF58<BR>
2007-08-21 23:11:16 LOG: redo done at 5/D42FAF28<BR>
2007-08-21 23:11:18 LOG: database system is ready<BR>
Thanks for your help<BR></FONT><br /><hr />Change is good. See what's different about Windows Live Hotmail. <a href='http://www.windowslive-hotmail.com/learnmore/default.html?locale=en-us&ocid=RMT_TAGLM_HMWL_reten_changegood_0607' target='_new'>Check it out!</a></body>
</html>