From: | m zyzy <myzyzy(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | failed insert queries to one table-postgis enabled db |
Date: | 2009-01-24 08:13:27 |
Message-ID: | a768d3db0901240013t52f439aao656ee65f4450c4e6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have two type of INSERT queries that keep getting errors no matter how
many times I run it in pgadminIII 1.8.4 PostgresQL 8.3.4+PostGIS1.3.5 on
centos5 Linux machine.
1. execution of 18MB INSERT queries to one empty table failed in postgis
enabled database.sample one of the thousands queries :
INSERT INTO lutons (gid, area, perimeter, map1a_, map1a_id, no_id, no_id2,
main, use_bgn, unit, lvls, hght, type_bgn, no_, name_biz, addrss, biz2,
code, bgn, code_bgn, builds, note, the_geom) VALUES (1,
1980.087000000000000, 179.134500000000000, 63, 0, '1001001', '1001001',
'Trade', 'Office', 1.000000000000000, NULL, '13', 'one', NULL, 'Wayne Co.',
'Elm Street', 'Office', '836', 'Good', 1, 'm', NULL,
'01060000000100000001030000000100000007000000CECAEFA1EEA34BC0F618A264232F69C0BF39315DC29748C01E53771C995369C0B0B8C50181173AC080DEED01F6D16BC0D28922835C2450C08EB4F082865E70C048D67B9E1CDA56C09B5ECFBE2B756DC0AF909ABFC40A4DC04CF2D285506169C0CECAEFA1EEA34BC0F618A264232F69C0');
in the Messages tab console in pgadminIII 1.8.4 prompts this error after
30-60 seconds of executing those queries
ERROR: geometry contains non-closed rings
********** Error **********
ERROR: geometry contains non-closed rings
SQL state: XX000
==========================================================================
2. 16mb insert failed . the problem query ;
INSERT INTO lutonszone (gid, area, perimeter, lot_no, unitadmin, zoning,
notes, the_geom, projectid) VALUES (23071, 3.071000, -9999.000000,
'0036\0178', 46, 'ru4', NULL,
'0106000020E61000000100000001030000000100000004000000C61858C7F112594099D87C5C1BDA154072A43330F2125940CC7D721420DA154049F7730AF21259',NULL);
in the Messages tab console :
WARNING: nonstandard use of escape in a string literal
LINE 23237: ...projectid) VALUES (23071, 3.071000, -9999.000000,
'0036\0178...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
ERROR: geometry requires more points
********** Error **********
ERROR: geometry requires more points
SQL state: XX000
From | Date | Subject | |
---|---|---|---|
Next Message | Volkan YAZICI | 2009-01-24 09:02:15 | SQL Source Search for Emacs |
Previous Message | Francisco Figueiredo Jr. | 2009-01-23 20:04:35 | Re: How to convert ByteA to Large Objects |