shp2pgsql generates fake fail full of zeroes

From: Raivo Rebane <raivore55(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: shp2pgsql generates fake fail full of zeroes
Date: 2023-03-04 15:33:20
Message-ID: 90C87B6A-2B17-43FB-AED0-84C8067DDC7F@hxcore.ol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=ET link=blue vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span lang=EN-US>I am usingPS F:\3D-data\Kataster&gt; shp2pgsql -g piirid SHP_KATASTRIYKSUS kataster &gt; kataster.sql under Windows 10<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>And it’s output is  full of zeroe<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>Cygwin helps to find them out,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>Raivo(at)DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>$ cat kataster.sql | less<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>&lt;FF&gt;&lt;FE&gt;S^(at)E^@T^@ ^(at)C^@L^(at)I^@E^(at)N^@T^(at)_^@E^(at)N^@C^(at)O^@D^(at)I^@N^(at)G^@ ^(at)T^@O^@ ^(at)U^@T^(at)F^@8^@;^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^(at)S^@E^(at)T^@ ^(at)S^@T^(at)A^@N^(at)D^@A^(at)R^@D^(at)_^@C^(at)O^@N^(at)F^@O^(at)R^@M^(at)I^@N^(at)G^@_^(at)S^@T^(at)R^@I^(at)N^@G^(at)S^@ ^(at)T^@O^@ ^(at)O^@N^@;^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^(at)B^@E^(at)G^@I^(at)N^@;^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^(at)C^@R^(at)E^@A^(at)T^@E^@ ^(at)T^@A^(at)B^@L^(at)E^@ ^@&quot;^(at)k^@a^(at)t^@a^(at)s^@t^(at)e^@r^@&quot;^@ ^@(^(at)g^@i^(at)d^@ ^(at)s^@e^(at)r^@i^(at)a^@l^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)t^@u^(at)n^@n^(at)u^@s^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)2^@5^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)h^@k^(at)o^@o^(at)d^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)m^@k^(at)_^@n^(at)i^@m^(at)i^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)1^@0^(at)0^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)o^@v^(at)_^@n^(at)i^@m^(at)i^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)1^@0^(at)0^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)a^@y^(at)_^@n^(at)i^@m^(at)i^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)1^@0^(at)0^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)l^@_^(at)a^@a^(at)d^@r^(at)e^@s^(at)s^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)2^@4^(at)0^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)r^@e^(at)g^@i^(at)s^@t^(at)r^@&quot;^@ ^(at)d^@a^(at)t^@e^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)m^@u^(at)u^@d^(at)e^@t^@&quot;^@ ^(at)d^@a^(at)t^@e^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)s^@i^(at)h^@t^(at)1^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@5^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)s^@i^(at)h^@t^(at)2^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@5^@)^@,^(at)^M^@<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>^@&quot;^(at)s^@i^(at)h^@t^(at)3^@&quot;^@ ^(at)v^@a^(at)r^@c^(at)h^@a^(at)r^@(^(at)4^@5<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>How to generate proper sql output<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>Regards<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p>&nbsp;</o:p></span></p><p class=MsoNormal><span lang=EN-US>Raivo<o:p></o:p></span></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows</p><p class=MsoNormal><o:p>&nbsp;</o:p></p></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 4.5 KB

Browse pgsql-general by date

  From Date Subject
Next Message Raivo Rebane 2023-03-04 15:53:10 shp2pgsql error under windows
Previous Message Peter J. Holzer 2023-03-04 11:51:52 Re: Dropping behavior for unique CONSTRAINTs