Hi,
Did you try
SELECT AsBinary("the_geom") FROM "demasz.teruletek_fr"
It works for me and I use it quite often (without quotes).
I'm not sure why AsBinary is necessary.
Michaël
Kis János Tamás a écrit :
Hi,
At the first time, I apploogize, that I speak/write very small
english...!
I have some maps in PostGIS: every schema (4 example: demasz) is an
theme collector, which contains some point, line {linestring} and
area {polygon} (4 example: teruletek_fr is an area) tables of
cadastral map.
When I tried "Layer->Add Datastore Layer", I saw the next message:
"Warning: org.postgresql.util.PSQLException: ERROR:
relation "demasz.teruletek_fr" does not exist (Runtime Exception)"
I found the problem: The OpenJump run next SQL:
SELECT extent("the_geom") FROM "demasz.teruletek_fr";
->ERROR: relation "demasz.teruletek_fr" does not exist
->SQL state: 42P01
SELECT AsBinary(find_extent( 'demasz.teruletek_fr', 'the_geom' ));
->ERROR: relation "demasz.teruletek_fr" does not exist
->SQL state: 42P01
->Context: SQL statement "SELECT extent("the_geom")
FROM "demasz.teruletek_fr""
->PL/pgSQL function "find_extent" line 7 at for over execute statement
Instead of:
SELECT extent("the_geom") FROM demasz.teruletek_fr; OR
SELECT extent("the_geom") FROM "demasz"."teruletek_fr";
->"BOX(690001 160000,720000 180000)"
SELECT AsBinary(find_extent( 'demasz', 'teruletek_fr', 'the_geom' ));
->"\001\003\000\000\000\001\000\000\000\005\000\000\000\000\000\000\000\242\016%A\000\000\000\000\000\210\003A\000\000\000\000\242\016%A\000\000\000\000\000\371\005A\000\000\000\000\000\371%A\000\000\000\000\000\371\005A\000\000\000\000\000\371%A\000\000\000\000\000\210\003A\000\000\000\000\242\016%A\000\000\000\000\000\210\003A"
The OpenJump not known the schemas...?
What I should to do at now?
When I tried "File->Load Dataset", it's all right, but I can't edited
the layer. I see the new elements, but I can't to save it.
Why? (I'm the postgres user.)
Thanks in advance!
bye,
kjt
McAfee SCM 4.1 által ellenőrizve!
------------------------------------------------------------------------
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
