<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
These are not the ERRORs messages Devrim was referring to. These are
merely NOTICEs that are typical for a PostGIS installation. Before all
the "ERROR: transaction was aborted" log entries you reported, there
should be a line that indicates what caused the transaction to roll
back.<br>
<br>
-- Kevin<br>
<br>
On 5/27/2010 2:14 AM, Peter Cotroneo wrote:
<blockquote
cite="mid:AANLkTilMJHWnIxvaitZ5tI05IcQMFfYtdxsneaLEfAsq@mail.gmail.com"
type="cite">
<meta http-equiv="Content-Type"
content="text/html; charset=windows-1252">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 11">
<meta name="Originator" content="Microsoft Word 11">
<link rel="File-List"
href="file:///C:%5CDOCUME%7E1%5CPCOTRO%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C04%5Cclip_filelist.xml">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<p class="MsoNormal">Hi Devrim,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks for your reply.<span style="">
</span>Here’s what I get immediately after trying to create a spatial
database:</p>
<p class="MsoNormal"> <br>
</p>
<p class="MsoNormal">[root@ip-10-224-82-127 postgis-1.5.0SVN]# sudo
-u postgres
createdb testdb</p>
<p class="MsoNormal">[root@ip-10-224-82-127 postgis-1.5.0SVN]# sudo
-u postgres
createlang plpgsql testdb</p>
<p class="MsoNormal">[root@ip-10-224-82-127 postgis-1.5.0SVN]# sudo
-u postgres
psql -d testdb -f postgis/postgis.sql</p>
<p class="MsoNormal">BEGIN</p>
<p class="MsoNormal">psql:postgis/postgis.sql:57: NOTICE:<span
style=""> </span>type "spheroid" is not yet defined</p>
<p class="MsoNormal">DETAIL:<span style=""> </span>Creating a
shell type definition.</p>
<p class="MsoNormal">CREATE FUNCTION</p>
<p class="MsoNormal">psql:postgis/postgis.sql:63: NOTICE:<span
style=""> </span>argument type spheroid is only a shell</p>
<p class="MsoNormal">CREATE FUNCTION</p>
<p class="MsoNormal">psql:postgis/postgis.sql:68: NOTICE:<span
style=""> </span>return type spheroid is only a shell</p>
<p class="MsoNormal">CREATE FUNCTION</p>
<p class="MsoNormal">psql:postgis/postgis.sql:73: NOTICE:<span
style=""> </span>argument type spheroid is only a shell</p>
<p class="MsoNormal">CREATE FUNCTION</p>
<p class="MsoNormal">CREATE TYPE</p>
<p class="MsoNormal">psql:postgis/postgis.sql:90: NOTICE:<span
style=""> </span>type "geometry" is not yet defined</p>
<p class="MsoNormal">DETAIL:<span style=""> </span>Creating a
shell type definition.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">As I mentioned yesterday, make check works just
fine (i.e.,
it creates the spatial database postgis_reg).</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Cheers,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Petrus</p>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>