Hi Vincent,
Enclosed i added a sample sql.dump of the table; i think u should be
able to restore etc and run some tests?
regards laurens
2010/1/18 Picavet Vincent <[email protected]>:
> Hello Laurens,
>
>> ad 1: as_EKWKT? Hmm .. i can't find that function in the postgis
>> functions, perhaps u mean 'asewkt'? A select with that function does
>> give tha same result sets on both platforms:
>> SELECT asEWKT(the_geom) FROM table WHERE gid = 1
>> results UNIX
>> "SRID=28992;MULTIPOLYGON(((121197.452 483388.474 0 0,121194.232643364
>> 483391.530431554 0
>> etc etc
>> results Windows
>> "SRID=28992;MULTIPOLYGON(((121197.452 483388.474 0 0,121194.232643364
>> 483391.530431554 0
>> etc etc
>
> Could you please post a fully self contained example ? Something with
> the geometry itself inside the query, so that I can execute your query
> on my own ? I've got several windows boxes with various flavours of
> windows, postgresql and postgis installed and can test this strange
> behaviour if you give me a working query without prerequisite.
>
> Thanks,
> Vincent
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
-- PostgreSQL database dump
--
SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = true;
--
-- Name: test_table; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
--
CREATE TABLE test_table (
gid integer NOT NULL,
ogc_fid bigint,
the_geom geometry,
CONSTRAINT enforce_dims_the_geom CHECK ((ndims(the_geom) = 4)),
CONSTRAINT enforce_geotype_the_geom CHECK (((geometrytype(the_geom) = 'MULTIPOLYGON'::text) OR (the_geom IS NULL))),
CONSTRAINT enforce_srid_the_geom CHECK ((srid(the_geom) = 28992))
);
ALTER TABLE public.test_table OWNER TO pgsql;
--
-- Data for Name: test_table; Type: TABLE DATA; Schema: public; Owner: pgsql
--
INSERT INTO test_table VALUES (1, 1, '01060000E0407100000100000001030000C001000000DA0000001E5A643BD796FD40894160E5F1801D41000000000000000000000000000000006B3FE8B8A396FD400773291FFE801D41000000000000000000000000000000000A22B2127096FD40805A834F0A811D410000000000000000000000000000000041A8DD483C96FD408871677616811D41000000000000000000000000000000006A8B865B0896FD40C236CF9322811D4100000000000000000000000000000000DE97C84AD495FD40E62DB4A72E811D4100000000000000000000000000000000ECACBF16A095FD40C3DF0FB23A811D4100000000000000000000000000000000C6BC87BF6B95FD4043DADBB246811D410000000000000000000000000000000076CC3C453795FD406FB011AA52811D4100000000000000000000000000000000CBF3FAA70295FD4071FAAA975E811D41000000000000000000000000000000004C5DDEE7CD94FD409855A17B6A811D4100000000000000000000000000000000294603059994FD405C64EE5576811D41000000000000000000000000000000002BFE85FF6394FD4061CE8B2682811D4100000000000000000000000000000000A6E782D72E94FD407B4073ED8D811D41000000000000000000000000000000006977168DF993FD40B06C9EAA99811D4100000000000000000000000000000000AE345D20C493FD403C0A075EA5811D41000000000000000000000000000000000DB973918E93FD4095D5A607B1811D41000000000000000000000000000000006AB076E05893FD406F9077A7BC811D4100000000000000000000000000000000E9D8820D2393FD40BC01733DC8811D4100000000000000000000000000000000DB02B518ED92FD40B4F592C9D3811D4100000000000000000000000000000000B0102A02B792FD40D43DD14BDF811D4100000000000000000000000000000000E9F6FEC98092FD40E5B027C4EA811D410000000000000000000000000000000006BC50704A92FD40FA2A9032F6811D410000000000000000000000000000000079783CF51392FD407B8D049701821D41000000000000000000000000000000009356DF58DD91FD4023BF7EF10C821D41000000000000000000000000000000007992569BA691FD4001ACF84118821D4100000000000000000000000000000000107ABFBC6F91FD4084456C8823821D4100000000000000000000000000000000F06C37BD3891FD407582D3C42E821D410000000000000000000000000000000053DCDB9C0191FD40FE5E28F739821D4100000000000000000000000000000000064BCA5BCA90FD40B0DC641F45821D4100000000000000000000000000000000594D20FA9290FD408102833D50821D41000000000000000000000000000000000F89FB775B90FD40D3DC7C515B821D41000000000000000000000000000000004DB579D52390FD40767D4C5B66821D41000000000000000000000000000000008E9AB812EC8FFD40AAFBEB5A71821D41000000000000000000000000000000008D12D62FB48FFD40247455507C821D41000000000000000000000000000000003A08F02C7C8FFD401009833B87821D4100000000000000000000000000000000AA77240A448FFD4014E26E1C92821D4100000000000000000000000000000000026E91C70B8FFD40552C13F39C821D41000000000000000000000000000000006C095565D38EFD40781A6ABFA7821D410000000000000000000000000000000004798DE39A8EFD40A6E46D81B2821D4100000000000000000000000000000000CAFC5842628EFD408FC81839BD821D410000000000000000000000000000000091E5D581298EFD406C0965E6C7821D4100000000000000000000000000000000EE9422A2F08DFD4006F04C89D2821D4100000000000000000000000000000000277D5DA3B78DFD40B2CACA21DD821D41000000000000000000000000000000002621A5857E8DFD405BEDD8AFE7821D410000000000000000000000000000000064141849458DFD4083B17133F2821D4100000000000000000000000000000000DEFAD4ED0B8DFD4043768FACFC821D41000000000000000000000000000000000089FA73D28CFD4051A02C1B07831D41000000000000000000000000000000009883A7DB988CFD40039A437F11831D4100000000000000000000000000000000C1BFFA245F8CFD404FD3CED81B831D4100000000000000000000000000000000D8221350258CFD40D5C1C82726831D410000000000000000000000000000000069A20F5DEB8BFD40D9E02B6C30831D41000000000000000000000000000000001C440F4CB18BFD404BB1F2A53A831D4100000000000000000000000000000000A91D311D778BFD40CAB917D544831D4100000000000000000000000000000000C35494D03C8BFD40A68695F94E831D41000000000000000000000000000000000B1F5866028BFD40E3A9661359831D4100000000000000000000000000000000FDC19BDEC78AFD403BBB852263831D4100000000000000000000000000000000E1927E398D8AFD402258ED266D831D4100000000000000000000000000000000B7F61F77528AFD40CA23982077831D410000000000000000000000000000000029629F97178AFD4023C7800F81831D41000000000000000000000000000000007B591C9BDC89FD40E0F0A1F38A831D41000000000000000000000000000000007770B681A189FD407955F6CC94831D41000000000000000000000000000000005F4A8D4B6689FD402FAF789B9E831D4100000000000000000000000000000000D999C0F82A89FD400BBE235FA8831D4100000000000000000000000000000000E2207089EF88FD40E847F217B2831D4100000000000000000000000000000000B9B0BBFDB388FD406E18DFC5BB831D4100000000000000000000000000000000D029C3557888FD401B01E568C5831D4100000000000000000000000000000000BC7BA6913C88FD4041D9FE00CF831D410000000000000000000000000000000022A585B10088FD400B7E278ED8831D4100000000000000000000000000000000A5B380B5C487FD4080D25910E2831D4100000000000000000000000000000000D8C3B79D8887FD4086BF9087EB831D41000000000000000000000000000000002C014B6A4C87FD40E333C7F3F4831D4100000000000000000000000000000000DCA55A1B1087FD404124F854FE831D4100000000000000000000000000000000DDFA06B1D386FD40328B1EAB07841D4100000000000000000000000000000000D057702B9786FD402F6935F610841D4100000000000000000000000000000000ED22B78A5A86FD409CC437361A841D4100000000000000000000000000000000F2D0FBCE1D86FD40CFA9206B23841D410000000000000000000000000000000013E55EF8E085FD400D2BEB942C841D4100000000000000000000000000000000E7F00007A485FD408E6092B335841D4100000000000000000000000000000000599402FB6685FD40826811C73E841D4100000000000000000000000000000000957D84D42985FD40106763CF47841D4100000000000000000000000000000000F468A793EC84FD405D8683CC50841D4100000000000000000000000000000000F1208C38AF84FD408BF66CBE59841D4100000000000000000000000000000000107E53C37184FD40BEED1AA562841D4100000000000000000000000000000000D1661E343484FD401BA888806B841D41000000000000000000000000000000009FCF0D8BF683FD40CE67B15074841D4100000000000000000000000000000000BABA42C8B883FD400C7590157D841D41000000000000000000000000000000002938DEEB7A83FD40141E21CF85841D4100000000000000000000000000000000A86501F63C83FD4033B75E7D8E841D4100000000000000000000000000000000956ECDE6FE82FD40C79A442097841D4100000000000000000000000000000000DE8B63BEC082FD403E29CEB79F841D4100000000000000000000000000000000F203E57C8282FD401DC9F643A8841D4100000000000000000000000000000000AB2A73224482FD40FFE6B9C4B0841D410000000000000000000000000000000040612FAF0582FD409AF5123AB9841D410000000000000000000000000000000030163B23C781FD40C06DFDA3C1841D410000000000000000000000000000000031C5B77E8881FD4061CE7402CA841D410000000000000000000000000000000022F7C6C14981FD408F9C7455D2841D4100000000000000000000000000000000F2418AEC0A81FD407F63F89CDA841D4100000000000000000000000000000000944823FFCB80FD408BB4FBD8E2841D4100000000000000000000000000000000EABAB3F98C80FD4038277A09EB841D41000000000000000000000000000000000FE5648AF57CFD4043869F791D851D41000000000000000000000000000000006F4037D3E77CFD40E75ECACE4E851D4100000000000000000000000000000000E39D8815387EFD409D1B5EA606891D41000000000000000000000000000000001B16BC7BC77FFD406A3BD3B55E8D1D4100000000000000000000000000000000539224693981FD40D7B66D23FF8B1D4100000000000000000000000000000000000000A03B91FD406BDBB675988B1D41000000000000000000000000000000008746C6060E96FD40E883C3AD038C1D4100000000000000000000000000000000DC9C96D41A9BFD40F07CD942DA891D4100000000000000000000000000000000DC72306E4F9BFD40E2718EBEC3891D41000000000000000000000000000000007489974D9B9BFD408E1F83E99F891D4100000000000000000000000000000000EB55FC88D19BFD40C6A20FB47B891D4100000000000000000000000000000000B11F647CF59BFD400D5D354B58891D41000000000000000000000000000000005AB4F1610C9CFD40E2141B8C3B891D41000000000000000000000000000000001F444487149CFD403A28E7D120891D410000000000000000000000000000000042F4FF5D199CFD40E2C107F0EF881D4100000000000000000000000000000000CCCCD4B5159CFD40AD770BDAD2881D4100000000000000000000000000000000012D492D30A1FD4004F86230D4881D41000000000000000000000000000000004CD5664943A1FD40BA3EBD5FD7881D4100000000000000000000000000000000CB73AAC881A2FD408BB2A52FFF881D4100000000000000000000000000000000BF19418294A8FD40FC70D218E9891D4100000000000000000000000000000000DBC2351783C6FD401E1DC9A63D8E1D4100000000000000000000000000000000752EE8E452C9FD400B17BF29A58E1D4100000000000000000000000000000000ED240E487ECAFD40279DCCDCE48E1D41000000000000000000000000000000002E7EBDAC53CDFD40C64ED6A206901D410000000000000000000000000000000002E042B8E2D2FD408A040C6455901D41000000000000000000000000000000006A677A843EE0FD408AC962CD12911D41000000000000000000000000000000004CEF4337C0F2FD4055B03F3519921D410000000000000000000000000000000064E5EBA8E9F2FD407A2D6200DA911D41000000000000000000000000000000004C2D5E9BC2F5FD402C066847828D1D41000000000000000000000000000000006F7C71F27CF7FD404608CCD1128C1D4100000000000000000000000000000000A51E58FCD4F8FD405B8BC848638B1D4100000000000000000000000000000000B5CF56FAB7FBFD40FC35753CEA891D410000000000000000000000000000000085DDFE640CFCFD403C345CD38E891D41000000000000000000000000000000006744696F0EFCFD401A96A99D8C891D4100000000000000000000000000000000AD69DE713AFCFD40C0A0EF420F891D4100000000000000000000000000000000C014AE4721FCFD40ADAEAD7390881D410000000000000000000000000000000089389B6B17FCFD4080F4997C85881D4100000000000000000000000000000000933A014DB0FBFD408B2038821C881D4100000000000000000000000000000000EA043411E2FAFD40A9589FC6A8871D410000000000000000000000000000000088F4DBD78FF9FD40B40D46C0F6861D4100000000000000000000000000000000742497FF24F8FD40238F4A8556861D41000000000000000000000000000000003EB6EB7915F8FD401D0C2B4D52861D4100000000000000000000000000000000567DAEB63CF6FD4035A389CBD1851D41000000000000000000000000000000004BC8073D7DF4FD40383D926666851D4100000000000000000000000000000000105839B40CF2FD40C690068BE1841D41000000000000000000000000000000001FF46C5671EFFD405041E87481841D4100000000000000000000000000000000965AA89A98EDFD40EEC947EF50841D410000000000000000000000000000000045DA33F40AEDFD40FA2886DA43841D4100000000000000000000000000000000FC3A70CEDAEBFD4063332AC427841D4100000000000000000000000000000000091B9E5EE5E9FD40A2F906FAFB831D410000000000000000000000000000000005341136F0E7FD401B74ACA6C9831D41000000000000000000000000000000003A234A7B25E7FD40FAA13C47B3831D4100000000000000000000000000000000E69A585996E4FD40119FAB814B831D4100000000000000000000000000000000F92E7FA7D6DDFD4034D6CED739821D410000000000000000000000000000000074B6347234DDFD40153F26D51A821D4100000000000000000000000000000000B5B3B5C464DCFD4086CE633DEB811D4100000000000000000000000000000000448B6716C2DBFD4093674AB4C1811D4100000000000000000000000000000000AC53B5FA52DBFD403E5268F896811D41000000000000000000000000000000004B37C6CC02DBFD40C8480FBC69811D4100000000000000000000000000000000A2AF9F1CCEDAFD409DEF639D3C811D41000000000000000000000000000000007CA2CF2DB4DAFD403B50265412811D4100000000000000000000000000000000B01F4B1794DAFD4037F49001DE801D410000000000000000000000000000000019B1389437DAFD4017441E194C801D41000000000000000000000000000000005B3EA9DE06DAFD406A4707EAFC7F1D41000000000000000000000000000000002E3D837ED4D9FD40E6197505AB7F1D41000000000000000000000000000000004685D37A83D9FD40D9394775237F1D4100000000000000000000000000000000CE10456353D9FD40DF92F37CB67E1D4100000000000000000000000000000000336E3A9F0DD9FD40772BF0365D7E1D41000000000000000000000000000000003983A8F3DED8FD40802290A3317E1D410000000000000000000000000000000092AFDE9A94D8FD4097C6DEAEFE7D1D4100000000000000000000000000000000640ABFCC53D8FD4026BE5444D27D1D4100000000000000000000000000000000F74AD22DB7D7FD40355A88E6817D1D4100000000000000000000000000000000B8ED64681ED7FD40474CCA35447D1D4100000000000000000000000000000000347194B458D6FD40C7948933E87C1D41000000000000000000000000000000005E26D926A2D5FD40262988C69B7C1D4100000000000000000000000000000000A65674B859D5FD405676C9737D7C1D4100000000000000000000000000000000CBDFA637ADD4FD407629EF3B357C1D410000000000000000000000000000000066C6C4DEABD3FD405C8B9012D07B1D4100000000000000000000000000000000966BCAD0BAD2FD407B49330F7C7B1D41000000000000000000000000000000004AB9E4B067D2FD40D11EA9165F7B1D4100000000000000000000000000000000BFD67F3F15D2FD40E5A4EBFA437B1D4100000000000000000000000000000000D547C9A343D1FD4073D3E00EFF7A1D4100000000000000000000000000000000906FD8AE5AD0FD4013CC1275B47A1D4100000000000000000000000000000000B363E10316D0FD4051F02144A27A1D4100000000000000000000000000000000D8E8839AC0CFFD406862A8A38B7A1D410000000000000000000000000000000073CC72CC5ECFFD40DD5AAFBA717A1D410000000000000000000000000000000088FFD9F6F7CEFD405949F68F5F7A1D41000000000000000000000000000000005B5EA27221CEFD40D32733363A7A1D41000000000000000000000000000000007B3012D2C6CCFD404621431F137A1D4100000000000000000000000000000000D20D2ED405CCFD40126E1106097A1D410000000000000000000000000000000001FA66931DCBFD409D7CF4DEFC791D4100000000000000000000000000000000D6B88FD8C5CAFD4027AD3C14FA791D4100000000000000000000000000000000437C495BD8C9FD40E6197585F2791D4100000000000000000000000000000000A08FB31A43C9FD402EEF510BEF791D410000000000000000000000000000000052F67F061FC8FD40DF295E3DE8791D41000000000000000000000000000000009FE90E5A8BC6FD404DEF5C70E2791D41000000000000000000000000000000002BA1A740D9C5FD409A2ABA17E3791D41000000000000000000000000000000002AE7745156C5FD4033F9C492E3791D4100000000000000000000000000000000D708340085C4FD40C7F11D36E9791D4100000000000000000000000000000000671349ECE0C3FD40C6D883A1ED791D41000000000000000000000000000000001B6D3EA631C2FD4001DAD025FC791D4100000000000000000000000000000000B8AE0526A0C1FD40711D093A007A1D4100000000000000000000000000000000412FC54DEBC0FD40BE9BE84B057A1D41000000000000000000000000000000002AB2CEBFCBBFFD402DBB62B7037A1D4100000000000000000000000000000000EAE2D16E42BFFD40FA122239017A1D4100000000000000000000000000000000FCAC1B67ACBEFD403850C97FFE791D41000000000000000000000000000000005D7433358ABEFD400CC3D8E0FD791D41000000000000000000000000000000005EBB518FADBDFD4049908EE2F5791D41000000000000000000000000000000006BEB63CAD5BCFD405ED4E4D1EA791D41000000000000000000000000000000006D15B01CF1BBFD408E5FF424DB791D4100000000000000000000000000000000320DF8393EBBFD40332219DACC791D41000000000000000000000000000000002F657BD56DBAFD405AF4E190B8791D4100000000000000000000000000000000EBA37C56B6B9FD40C54FAE82A4791D410000000000000000000000000000000070BA0C77F7B8FD40CA4BF4B187791D410000000000000000000000000000000054AD5A296DA2FD4032C6C9BD567E1D41000000000000000000000000000000000DD6BB64669BFD40793BF55AEB7F1D41000000000000000000000000000000001D5A643BD796FD40894160E5F1801D41000000000000000000000000000000001E5A643BD796FD40894160E5F1801D4100000000000000000000000000000000');
--
-- Name: test_table; Type: ACL; Schema: public; Owner: pgsql
--
REVOKE ALL ON TABLE test_table FROM PUBLIC;
REVOKE ALL ON TABLE test_table FROM pgsql;
GRANT ALL ON TABLE test_table TO pgsql;
--
-- PostgreSQL database dump complete
--
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
