[Qgis-user] Problem with postgis table in qgis 1.80

Siegfried.Blank at lazbw.bwl.de Siegfried.Blank at lazbw.bwl.de
Thu Jul 26 08:13:32 PDT 2012


Hallo,
i have some problems with data from postgresql db (v. 9.1.3) only in qgis 1.80.  The spatial data will view, but in the attribute table is shown in some rows only ERROR. In this case the corresponding value in the Identify Results is a big negative value - it looks like an overflow error?! 
I have tested it on Win and Ubuntu with the same result. In the db manager the table will shown right, but the qgis browser has the same problems.
In qgis 1.7.4 all works proper!

Appending the sql-Code of the test-table.

Many thanks for any help!

Siegfried Blank

------------------------------------------------------------
Landwirtschaftliches Zentrum für Rinderhaltung,
Grünlandwirtschaft, Milchwirtschaft, Wild und Fischerei
Baden-Württemberg (LAZBW)
Fischereiforschungsstelle Baden-Württemberg
(Fisheries Research Station)
Argenweg 50/1
88085 Langenargen
Tel.: 0049-(0)7543-9308313
Fax: 0049-(0)7543-9308320
(Germany)
http://www.lazbw.de <http://www.lazbw.de/> 
----------------------------------------------------------- 


--
-- PostgreSQL database dump
--

-- Dumped from database version 9.1.3
--

CREATE TABLE tbl_test (
    probestellennummer bigint NOT NULL,
    the_geom public.geometry
);


INSERT INTO tbl_test VALUES (6402145001, '0105000020EB7A0000010000000102000000170000004C3789319C3C4B41FCA9F10AF8535441931804869D3C4B4121B072B0F45354417D3F357EA13C4B41E4839E65EA5354411904563EA53C4B41E5D0224BE4535441F6285C7FA93C4B410C022BAFDD5354416C787A1DAD3C4B41E0BE0E48D85354417593187CB33C4B417E8CB967D15354412BF69795B63C4B41BADA8A15CE5354412BF69795B63C4B41BADA8A15CE535441516B9A87C23C4B41E4141D49C1535441EF3845A7CD3C4B41EC51B806B6535441F7065F70D13C4B411D3867ACB2535441EA0434F1E13C4B4199BB9680A653544157EC2F4BF43C4B4148BF7D3199535441A779C7D9013D4B413D9B55EF8F5354414C3789491E3D4B41E4839EBD7E5354415EBA49FC2E3D4B41705F073E74535441AF25E40B3C3D4B41CE88D2EA68535441F7065F78453D4B410E2DB2295F535441AED85F964B3D4B41AED85FD25553544170CE88BA4E3D4B419CA2230D4E535441CE1951B2523D4B41BBB88D7E40535441E9263178523D4B4154E3A51335535441');
INSERT INTO tbl_test VALUES (6401063001, '0105000020EB7A00000100000001020000008D000000A167B32A3B214B413411369C1E4A5441CE19511239214B4168226C8C1F4A5441E09C11CD2D214B416F128398244A54413333337B21214B41DF4F8D3B2A4A5441E63FA4E716214B4198DD93672F4A5441DD2406010A214B41DC4603CC354A5441DD240609F9204B41A8C64B8F3F4A54417FD93D39F2204B41759318B4434A5441499D8086ED204B410E4FAF34474A5441E6AE250CED204B418716D99A474A54414A0C0223E7204B41F5DBD7E94D4A5441984C1504E6204B41B6847C504F4A54413BDF4F65E0204B414694F656564A5441AED85F9EDC204B413EE8D9585A4A54418CB96BA1DB204B4111363C655B4A544103098AC7D9204B413D2CD4F65C4A544122FDF6C5D4204B41B003E734614A5441E71DA748CF204B414260E514654A544104E78CD8CE204B41B98D0664654A5441F931E6F6C9204B41000000B4684A5441363CBD62C4204B41BD5296B96B4A5441894160D5B7204B4196438BD0724A5441FA7E6A5CB3204B4194878506754A5441986E129BAD204B4160E5D0DE774A5441C5FEB213A4204B41DE9387857B4A5441F0A7C68B97204B4117D9CE077F4A5441378941C084204B41BA490C12834A5441F0A7C64B6F204B41355EBAB9864A54414772F99F6D204B4185EB51EC864A54415986386E65204B413A92CB5F884A5441BE30997A5D204B419CA22391894A54418CDB68F85A204B41903177F1894A54414B5986B84D204B41CA54C1388B4A5441DD24060145204B418104C5AF8B4A5441F7065FB02E204B413108ACAC8C4A54414850FCB818204B410534116E8D4A54414C37896109204B417D3F35D68D4A5441FB5C6D2DFD1F4B41C74B374D8E4A5441D578E9FEF31F4B41516B9A978E4A54418FE4F2E7EC1F4B41A323B9888E4A5441645DDCA6E91F4B41C74B374D8E4A54412497FFD0E51F4B418F5374B88D4A54419A9999D1E01F4B4183C0CA9D8C4A54419EEFA796DF1F4B41ED0DBE408C4A54414A0C0243DE1F4B4141F163DC8B4A54418B6CE713DA1F4B4152499DD08A4A54415DFE4332D51F4B41302AA9F7874A5441C286A7EFCB1F4B41BF0E9C47804A54411904562EC61F4B4117D9CE177C4A5441A8C64BB7BE1F4B41CFF75323774A5441FA7E6A3CBA1F4B413F355E0A754A544193180436B51F4B41A69BC4B0724A54414C378921AF1F4B41F853E345704A544167D5E712AD1F4B414182E2FB6E4A54416F81046DAA1F4B410B4625D16D4A54410E4FAF449F1F4B41567DAE7E664A544193A98239991F4B4196438BD8614A5441545227A8961F4B41A1D6344F5F4A5441E4839E75941F4B41956588235D4A544168B3EA33901F4B4117B7D16C594A5441A779C711891F4B419B559F33534A544119045636821F4B41857CD0FB4C4A5441E8D9ACEA731F4B412A3A925F404A5441A4703D2A701F4B411CEBE2AE3C4A5441107A366B641F4B412EFF214D324A544189D2DEF8601F4B4132E6AEE12E4A5441AB3E5753571F4B41E8D9ACEE254A5441AB3E5753571F4B41E8D9ACEE254A5441613255604E1F4B414ED191F81D4A5441613255604E1F4B414ED191F81D4A5441832F4CF6441F4B41567DAEF6144A54415305A3C23F1F4B414D840D2B104A5441759318243D1F4B4154E3A53B0D4A5441865AD354391F4B41D42B65F9084A5441BF7D1DF8351F4B4144696F1C044A5441D578E9FE2E1F4B41B4C8768EFC49544116FBCB462B1F4B418FC2F514F8495441A1D634DF2A1F4B41567DAEBAF7495441CA32C4E1291F4B410C93A956F649544104E78CA0251F4B41075F9818F149544198DD935F231F4B41C442AD51EE495441857CD01B221F4B41FE65F7C8EC4954416519E2181D1F4B41F4FDD4B4E6495441022B877E191F4B4152499D44DF495441C976BE6F181F4B415BB1BF28DB4954415BD3BCFB171F4B4105341166D9495441EB73B50D171F4B416DE7FB5DD24954416744694F151F4B4110E9B7D3C4495441C0EC9ECC131F4B414A0C0223B549544121B072B8131F4B4155302A41B0495441645DDCAE131F4B41832F4CEEAD4954415474247F141F4B418CDB68ECA4495441CC7F486F151F4B41022B87CE9F495441EB73B50D171F4B41B7D100FA9649544153962176181F4B41BE3099B68B49544127C28607191F4B4103098A2B8749544127C28607191F4B4103098A2B8749544160E5D062191F4B419CC420C08549544176E09CE1191F4B41F7E461A182495441728A8E6C1A1F4B4109F9A03B7D495441BEC117961B1F4B4198DD93E3724954412041F1831C1F4B413480B7386F4954417F6ABC941C1F4B41F853E3A56E4954416ABC74131E1F4B41355EBA5967495441E63FA4CF1F1F4B41EE7C3F255E49544104560ECD211F4B417D3F351E54495441894160E5221F4B41F853E3B5494954414C3789C1241F4B415EBA492C3F4954416AC3C595241F4B41498F630A3F495441D122DB19261F4B41A69BC4F03349544121B07230261F4B4141F163943049544167D5E782261F4B41D0B359212F495441B30C71AC271F4B410BB5A6A12C495441DA1B7C11291F4B4134A2B43F2A49544116FBCB462B1F4B41643BDF572749544109F9A0B72D1F4B41DFE00BE724495441BC969057341F4B41E3C7980B1E495441FE43FACD391F4B4182E2C75C17495441F2D24D7A3C1F4B410DE02DE01349544188855AFB3C1F4B41DDB584F012495441F5B9DA1A3E1F4B41508D97DA104954411D5A64BB3F1F4B411283C0F20D495441A245B623411F4B411A51DAEB094954413F355E5A411F4B41C7293A0A09495441A8C64B97411F4B418716D90E08495441560E2D12421F4B4121B0724802495441DBF97EAA411F4B419CC420F0FB485441E3A59BB4401F4B41C442AD65F6485441E63FA46F401F4B4117D9CED7F4485441BC7493F83F1F4B414A0C022BF2485441894160C53D1F4B41355EBA59E94854417FFB3A003B1F4B41304CA6FAE2485441560E2DD23A1F4B41A69BC490E24854410E2DB27D371F4B412B871629DC485441F931E61E371F4B41D9CEF79BDB48544189416025331F4B41B07268B1D5485441C74B37E92D1F4B413F355E4ACF4854414F4013812B1F4B4143AD69DECC4854412DB29D0F291F4B412B871669CA485441CAC34295251F4B4166F7E411C748544155302AE91D1F4B4125750202C1485441');
INSERT INTO tbl_test VALUES (6501038002, '0105000020EB7A00000100000001020000002B0000004260E5B0AA334B412DB29D87EC765441621058C9A2334B41736891B5EC765441B30C710CA2334B41AD69DEB9EC765441D578E9B69A334B4196438BE4EC765441B072685188334B41F6285C77EE765441A245B6E376334B41E17A1486F07654413789419070334B41F54A599EF1765441560E2D0264334B4177BE9FCAF376544185EB510854334B4181954393F6765441C1CAA1953B334B41DBF97E62FC765441C1CAA1552C334B41E5D0222BFF765441022B878627334B41F2D24DC2FF765441FED478891E334B411B2FDDDC00775441759318340A334B41B81E85E3037754411FF46C16FF324B411CEBE22E05775441E71DA788F8324B410F9C33F205775441AAF1D25DEE324B410C022B4F067754410C022BB7E3324B4185EB5138057754413108AC9CE3324B4181954333057754413108AC6CE0324B4123DBF9960477544139B4C856D8324B4177BE9F0A03775441F7065FE8CE324B41B1E1E9F5FE76544171AC8BDBCC324B41A857CA12FE765441D34D62C0CB324B4185EB5198FD7654410A68228CCA324B41DBF97EA2FC7654415C8FC295C1324B41FA7E6A7CF5765441E6AE2544BC324B417DD0B3D9EF7654412D431C6BB7324B418716D9B6EA76544146B6F31DA2324B412DB29D47DD7654419EEFA7E69C324B41A8C64BE7DA7654415DDC46C397324B41E3361A90D87654416210583997324B4114AE4751D8765441EEEBC07994324B41C5FEB27BD77654414ED191CC8D324B41F085C974D5765441E5D022AB89324B413D0AD733D4765441BBB88D3685324B41C7BAB875D3765441BBB88D3685324B41C7BAB875D3765441F9A067B384324B41F90FE95FD37654414E6210F87D324B412E90A040D276544114AE47B179324B41560E2D8AD176544114AE47B179324B41560E2D8AD17654417B14AEC767324B416ABC747BCF765441A4703D6A54324B4119045616D0765441');
INSERT INTO tbl_test VALUES (6451017002, '0105000020EB7A000001000000010200000010000000C2172633A8404B41B8AF03172A735441B1E1E97582404B41AAF1D20D1F7354418F5374F44F404B41D734EF4810735441E09C11E53D404B417FD93D810B7354417AC7292A30404B41666666D607735441A2B4376825404B4133C4B1BE04735441A52C433C20404B41C139234203735441166A4D131E404B417AA52CA302735441865AD30C17404B41A3923A41007354411F85EBB10F404B4105A392C2FD7254411361C33309404B41B515FBF3FA725441FBCBEE1900404B4138F8C204F7725441A60A46C5E63F4B41AA825111EC725441D8817326C33F4B41A301BC15D6725441107A361BC13F4B41499D801ED472544171AC8B8B9B3F4B41EC51B8FEAF725441');
INSERT INTO tbl_test VALUES (6503036003, '0105000020EB7A000001000000010200000031000000E7FBA9E93D6A4B413D9B5503738A54414850FC08406A4B419A9999E9758A5441EFC9C3A2416A4B41F31FD223778A5441E7FBA989426A4B417B14AE57788A544137894128486A4B413A92CB3B7D8A5441BA490CB24B6A4B414BC807F5828A5441736891354C6A4B41C13923A28C8A544148BF7D3D486A4B41E71DA7909A8A54416EA301FC456A4B416A4DF3BA9C8A544189D2DE98436A4B41FBCBEE9D9E8A54417B14AE47416A4B41C286A7679F8A54419A081B4E3C6A4B415DFE431AA18A5441516B9A47316A4B41956588FBA18A544187A7579A1C6A4B41E3A59B98A28A54414E621080136A4B41933A011DA38A5441D26F5F970B6A4B41A835CD97A28A5441029A08A3076A4B41BF7D1D58A18A5441B0726829046A4B419B559FFF9E8A5441B0726829046A4B419B559FFF9E8A5441B0726829046A4B419B559FFF9E8A5441EA0434D1026A4B41378941549E8A5441EA0434D1026A4B41378941549E8A544162105801016A4B41A8C64BC39D8A5441B003E724006A4B41D509687E9D8A54412D431C9BFC694B416D567D2E9D8A54412D431C9BFC694B416D567D2E9D8A544151DA1BCCFB694B41CA54C1409D8A544186C95411F9694B41D509687E9D8A544161325568F2694B41D6C56D18A08A54410C022B5FEC694B41933A011DA38A5441B7D10056E6694B41E6AE258CA68A544113F24157E1694B414F1E1676A98A5441BDE3144DDE694B41A52C43D4AA8A5441E4839E2DDD694B41E4839E55AB8A5441174850C4D7694B41B98D0660AC8A544116FBCBC6CD694B41E63FA4EFAD8A54416F81043DCA694B41D044D874AE8A5441984C1564C2694B41A835CD5BAF8A54416ADE7192B7694B411895D479B28A5441B37BF280AF694B41B6F3FDC8B68A54413D0AD7BB9F694B417958A84DBE8A544180B7405295694B4141F16390C48A54413D9B553F91694B416ABC7403C78A544101DE02A188694B41B072689DCD8A544105C58F5987694B410E2DB2B1CE8A54411826530D82694B41F241CFF2D38A54413F575B9180694B41C976BED7D68A5441B6847C0080694B4180B740F2D78A54410B4625A57E694B410AD7A300E28A5441');
INSERT INTO tbl_test VALUES (6351000001, '0105000020EB7A00000100000001020000002F000000D734EFA8A0084B41DDB584940B6454413EE8D96CB0084B41613255480B645441840D4F6FBF084B4142CF662D09645441151DC995D4084B41107A36C3036454416ABC7443FB084B41C898BBA6F363544133C4B1FE13094B4176E09C59E96354412063EE7A22094B413D0AD743E5635441E258177735094B415C8FC255E363544134A2B46744094B41C3F5284CE4635441984C15FC7D094B4119E258AFF1635441143FC66C90094B41FBCBEE71F1635441B8AF0357B1094B4114AE4731ED635441575BB1EFC9094B41AA6054EEE66354415C8FC295EB094B419031775DDE6354413D2CD4BA1B0A4B41BDE314B5D463544151DA1B1C370A4B4167D5E73ACD635441F775E08C5A0A4B419A081B2EBD6354413411369C670A4B41FB5C6D1DB7635441840D4F6F7A0A4B4101DE02F9A96354417AA52CF38A0A4B41B8AF0387A4635441AEB6622F9B0A4B418BFD65EFA2635441A2B43718DD0A4B41D88173C6A1635441D7A370FDED0A4B4148E17A24A3635441711B0D00FD0A4B418048BF35A6635441E3C7988B130B4B41C364AAE0AE63544185EB51181E0B4B41143FC68CB56354413F575B013F0B4B4162A1D6ACD36354413F575B013F0B4B4162A1D6ACD3635441EB73B5D5430B4B417CF2B0D0D5635441CC7F488F500B4B414E621060D6635441ED0DBED0610B4B4194F606E7D5635441D6C56D747A0B4B41D7A3702DD3635441F697DD23960B4B41B81E85DBCB63544187A7572A9D0B4B41A835CD73C86354415227A099A20B4B41E6AE253CC3635441956588D3A80B4B418A1F632EB963544101DE02E9B00B4B4152499D20AC63544100917E2BB80B4B415DFE435AA6635441A9A44E90BE0B4B412A3A9253A26354410F0BB55ECB0B4B414C378929A1635441B98D0640E30B4B4133C4B1AEA56354419CC420F0E70B4B41C6DCB5BCA5635441ADFA5CBDFB0B4B41C286A7F7A5635441CC5D4B78380C4B41857CD0139D63544152B81EC5690C4B41FBCBEE9199635441E10B9379740C4B4171AC8BBB99635441931804B6A40C4B416E3480BF93635441');
INSERT INTO tbl_test VALUES (6302035003, '0105000020EB7A00000100000001020000003B000000545227D0DB034B416666667A93655441711B0DC8D5034B416666667A93655441401361E3CE034B41F697DD1B936554411973D75AC7034B4132E6AE4193655441BF7D1DF8BF034B41F697DD1B93655441A089B089BB034B41E3A59B8492655441E4141DA1B5034B419E5E291392655441FA7E6A74AE034B41956588C791655441AE47E112A9034B41956588C791655441B30C71A4A4034B414A7B839792655441857CD05BA0034B417958A81194655441BE3099929C034B418716D93296655441EEEBC0A19B034B413CBD52BA96655441C74B371994034B417F6ABCF89B6554415C8FC24D8D034B41933A01BD9F655441F697DD8B87034B4146B6F39DA2655441780B240885034B41B003E7CCA36554411895D4B97B034B415DFE437EA76554413411360473034B41C21726ABAA65544154E3A58B6D034B4139D6C5A9AC6554413789418063034B418126C2A6B06554415BB1BF545E034B41E25817FBB1655441B22E6E0359034B41A167B316B3655441ACADD81757034B41696FF07DB4655441ACADD81757034B41FF21FD0AB66554411283C06A57034B41D49AE6F5B66554414F40130157034B41E25817A3B765544186C954E955034B41E4141D55B86554414BC807F552034B41ED0DBEA0B86554411361C31B50034B4133333327B8655441CD3B4EB94E034B41006F81ACB7655441F4FDD4C04C034B4112143FA2B66554410BB5A6E948034B41158C4A02B56554411AC05B3045034B4103098AE3B46554411AC05B3045034B4103098AE3B465544142CF665544034B41D93D79DCB465544174B5153B42034B411058391CB565544174B5153B42034B411058391CB565544121B072B83E034B415305A386B5655441EFC9C3B239034B4179E926B5B6655441F38E534435034B411B0DE0EDB665544188635D1432034B418AB0E1A5B6655441E561A13E30034B4144696F7CB665544116FBCBBE29034B41E3361A28B5655441143FC66423034B412D211F58B4655441F31FD2C71D034B418BFD651FB465544104560E0518034B41BD5296F9B3655441B30C71BC13034B41AA605462B3655441DDB5847C10034B41EC51B846B2655441ADFA5CE50E034B41DC68005BB1655441AEB6626F0D034B41FFB27B82B06554412041F1930A034B41226C78B2AD6554416ADE711A07034B41A245B6C7AB655441AEB6622704034B4158A835F1AA6554410A6822DC01034B41151DC985AA6554416891ED3C00034B411895D439AA655441DC460300F9024B4176711B01AA6554412D431CC3F1024B4188635D98AA65544109F9A01FEE024B418E06F08EAB655441');
INSERT INTO tbl_test VALUES (6351000002, '0105000020EB7A0000010000000102000000160000009FCDAA8F7B064B41992A18753E635441371AC0EB7C064B4131992A28406354410E4FAFA47E064B41A301BCAD446354419A081BCE85064B415C2041F14E6354414A7B83D78B064B417B832FA4566354411F85EB118D064B41E78C28355863544148E17A34CB064B412FDD24EE80635441F46C56CDD5064B4152499D5086635441F54A5936DB064B415DDC46F38863544166F7E4D1E5064B41423EE8B18D635441865AD32CF1064B41C3F5284C906354414772F93F39074B4152B81E259A635441849ECD3A48074B41A301BC259D635441539621CE59074B4148E17A24A3635441C1A8A4DE86074B4100917E9BBA63544114AE4721C1074B41151DC995DE6354415C8FC2F5DC074B41BD529609E76354412B18953402084B419EEFA7DEEF6354419031775D1D084B415227A0B9F36354416EA301FC24084B41DD240639F363544129CB10D73E084B414D840D77F7635441287E8CD97C084B414C37893905645441');
INSERT INTO tbl_test VALUES (6505130001, '0105000020EB7A00000100000001020000001A000000F775E0D430754B4174469452079B5441D93D79E825754B413B70CE740E9B5441C3D32B8D1E754B414ED191E8109B5441DDB584440A754B417B832FE8159B5441FC187357FF744B4190317799189B54415396210EEB744B413CBD52F21C9B544155302A59DE744B41105839D81F9B54413BDF4F35D5744B41CDCCCC4C239B54416DE7FB81CA744B41C442AD51299B5441006F815CBF744B410DE02D58319B54410612148FB7744B41E17A143E349B54419D802632AE744B4192CB7F94359B5441EE5A42B6A1744B411C7C61CE369B5441DDB584AC95744B416EA301D0389B5441355EBAC18C744B41A167B30A3B9B5441DC68002F87744B41A9A44E603B9B5441956588F37C744B41D0B359AD3B9B5441A5BDC12776744B41061214873D9B5441F0A7C65B6F744B411F85EB19439B54419A081BBE62744B416ADE71724D9B5441D734EF085D744B41BC749320529B5441492EFF3159744B414D840D47559B544186C954A158744B41304CA60A569B54418FE4F2AF53744B41158C4ACE599B5441787AA5544C744B418638D661609B54419D80265245744B41C442ADAD6E9B5441');
INSERT INTO tbl_test VALUES (6505130002, '0105000020EB7A00000100000001020000001300000029ED0D4E31784B4135EF389531945441C217261322784B416C787AB53894544129ED0D4E20784B41E02D9044399454416A4DF30E05784B412A3A92CB449454412653052BEF774B419D11A5754E9454412653052BEF774B419D11A5754E945441E5D02263E5774B41E561A1EE5394544106121447D9774B411D5A64F75B945441C976BEC7CD774B419A081BDE649454411C7C61DAC3774B412575023A709454411C7C61DAC3774B412575023A70945441182653B5BD774B4187A757827994544190A0F8B1B9774B41DC680067819454414F401381B7774B41AD69DE5184945441C364AA30B5774B41E6AE250C87945441E3361AA0B2774B418A1F63D6899454413D0AD743AE774B41C8073D838D9454415DDC4653AB774B412063EECA8F945441D7A370BDA7774B413D0AD76392945441');
INSERT INTO tbl_test VALUES (6504126001, '0105000020EB7A0000010000000102000000240000003E795818C46D4B4188635D1862875441EC2FBB47A56D4B4175029AA069875441F2B05093896D4B419D80268A6E87544160764F5E716D4B41865AD3687287544111363C4D606D4B415C20410D76875441158C4ABA566D4B41D93D792C79875441F1F44A11506D4B41575BB14B7C87544199BB9628486D4B417FD93DC580875441ED9E3C34446D4B413F575BA9858754414BC80715416D4B41A835CDE78B875441E86A2BEE406D4B41840D4F438D8754410E2DB20D406D4B410C022B1B958754415C8FC2F5406D4B416B2BF63FAB8754416744690F3F6D4B414850FCF8B2875441AD69DE91386D4B41431CEB1ABD875441F697DDE32F6D4B4167D5E7DAC58754417B14AE072C6D4B4194F606B7CD875441D6C56D142C6D4B4124287EF4DD875441D6C56D142C6D4B4124287EF4DD8754415EBA49FC2C6D4B41F2B05073E287544177BE9F5A2F6D4B417F6ABC34EE875441C364AAD02F6D4B41567DAE7EF08754417B14AE47236D4B41CD3B4E410D8854417B14AE47236D4B41CD3B4E410D8854417B14AE47236D4B41CD3B4E410D885441B6847C401E6D4B41F46C56B51688544148BF7DDD1C6D4B410AD7A35019885441D734EFC8196D4B411B0DE0E51B885441158C4AAA0E6D4B412497FF3825885441FA7E6AB4016D4B4196218ED52C88544100917E8BFE6C4B4199FE40C32E885441ED9E3C2CF96C4B41B537F81A3188544167D5E7DAEB6C4B41575BB117378854413D9B55AFD76C4B41D200DE1A3E8854415DFE432AC96C4B41E78C28A5418854413E7958B8AC6C4B41D26F5F2F47885441');
INSERT INTO tbl_test VALUES (6402145003, '0105000020EB7A0000010000000102000000120000009D8026C285334B41AAF1D2DDE66654413F355E1A83334B412B8716A1E26654416ABC74F377334B41C1392326D3665441764F1E866B334B41713D0A1BC46654413F575B8961334B41B6F3FD08B46654413D2CD48A56334B41E4839EF1A4665441333333534D334B412731087C99665441B1506BC241334B417A36ABA28966544160E5D0FA35334B410A6822007A665441EC51B88E29334B418A1F63C268665441228E75591D334B41EF38453B5966544146B6F33515334B41B7D1006A51665441C898BB360F334B41014D84614C665441D5E76A9305334B417F6ABC3445665441D044D878F9324B415C20418D3C665441D044D878F9324B415C20418D3C665441A8C64B879D324B419CC420680166544144696F187C324B415E4BC80FEB655441');

ALTER TABLE ONLY tbl_test
    ADD CONSTRAINT pri PRIMARY KEY (probestellennummer);


CREATE INDEX gist ON tbl_test USING gist (the_geom);




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120726/e624e84b/attachment.html>


More information about the Qgis-user mailing list