Adding PostGIS Sql view

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Adding PostGIS Sql view

César Arriaga Egües
Dear friends.

I have created a database view in Postgres/PostGIS based on two 1:1 related tables.

create view cat_building_v
  as select g.idbuilding, d.text, g.geom
  from cat_building_data d inner join cat_building_geo g
  on d.idbuilding = g.idbuilding;

I am trying to add this view to a new map in uDig but the view is not even listed in the "add layer from Postgis" wizzard.

I have been reading some posts of 2006 talking about the same issue, but in that time, it seem that the view could be listed in the same dialog.

Also checked the PostGIS geometry_columns view in which both cat_building_geo TABLE and cat_building_v VIEW are returned with the same attributes.

f_table_catalog f_table_schema  f_table_name          f_geometry_column coord_dimension srid    type
TestDB            public               cat_building_geo geom                 2               25830      POINT
TestDB            public               cat_building_v   geom                 2               25830      POINT

The same view can be rendered in QGIS with the same connection parameters (user).

Is there a way to render database views in uDig.

Thanks in advance.

César Arriaga.

________________________________

AVISO SOBRE CONFIDENCIALIDAD: La información incluida en este mensaje es CONFIDENCIAL y de uso EXCLUSIVO a su FINALIDAD. Su posterior divulgación será responsabilidad de quien la realice
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: Adding PostGIS Sql view

Mauricio Pazos-2
Hi, maybe you have found a bug. Could you attach the log? It is available in :

Help > Submit Issue

Please, provide some details about your installation (udig version, operating
system)

cheers

--
Mauricio Pazos


On Saturday, March 08, 2014 02:39:02 PM César Arriaga Egües wrote:

> Dear friends.
>
> I have created a database view in Postgres/PostGIS based on two 1:1 related
> tables.
>
> create view cat_building_v
>   as select g.idbuilding, d.text, g.geom
>   from cat_building_data d inner join cat_building_geo g
>   on d.idbuilding = g.idbuilding;
>
> I am trying to add this view to a new map in uDig but the view is not even
> listed in the "add layer from Postgis" wizzard.
>
> I have been reading some posts of 2006 talking about the same issue, but in
> that time, it seem that the view could be listed in the same dialog.
>
> Also checked the PostGIS geometry_columns view in which both
> cat_building_geo TABLE and cat_building_v VIEW are returned with the same
> attributes.
>
> f_table_catalog f_table_schema  f_table_name          f_geometry_column
> coord_dimension srid    type TestDB            public              
> cat_building_geo geom                 2               25830      POINT
> TestDB            public               cat_building_v   geom              
>  2               25830      POINT
>
> The same view can be rendered in QGIS with the same connection parameters
> (user).
>
> Is there a way to render database views in uDig.
>
> Thanks in advance.
>
> César Arriaga.
>
> ________________________________
>
> AVISO SOBRE CONFIDENCIALIDAD: La información incluida en este mensaje es
> CONFIDENCIAL y de uso EXCLUSIVO a su FINALIDAD. Su posterior divulgación
> será responsabilidad de quien la realice
> _______________________________________________
> udig-users mailing list
> [hidden email]
> http://lists.refractions.net/mailman/listinfo/udig-users

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: Adding PostGIS Sql view

César Arriaga Egües
uDig version: 1.4.0 x86_64.
OS: W7_64.
PostgreSQL: 9.2.4
PostGIS: 2.0

I have started with a new .log file, doing the following:
-Start uDig.
-Create new map.
-Add layer-> Postgis -> Connect to server -> Select database -> "List" button.

As result: tables are listed but views are not listed.

There are not logs in the log file further these of starting uDig (no logs associated to the "list" action).

I've tested also with VERSION 2.0.0.ALPHA1-V20131119, with the same results.

Regards,

César

!SESSION 2014-03-12 12:33:11.625 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_17
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en
Command-line arguments:  -os win32 -ws win32 -arch x86_64

!ENTRY net.refractions.udig.ui 1 0 2014-03-12 12:33:17.820
!MESSAGE net.refractions.udig.ui.WorkbenchConfiguration "net.refractions.udig.internal.ui.UDIGWorkbenchConfiguration" specified but no valid extension found.
Please check that the extension exists and that it is valid.

!ENTRY net.refractions.udig.ui 1 0 2014-03-12 12:33:17.857
!MESSAGE net.refractions.udig.ui.MenuBuilder "net.refractions.udig.ui.uDigMenuBuilder" specified but no valid extension found.
Please check that the extension exists and that it is valid.

!ENTRY net.refractions.udig.catalog 4 0 2014-03-12 12:33:18.405
!MESSAGE Restoring Local Catalog

!ENTRY net.refractions.udig.catalog.imageio 2 0 2014-03-12 12:33:18.446
!MESSAGE GDAL Not Available ... some image formats disabled:
Expected environment variable resolve to:
        LD_LIBRARY_PATH=null
        DYLD_LIBRARY_PATH=null
        GDAL_DATA=C:\Program Files\PostgreSQL\9.2\gdal-data
        java.libary.path=C:\Program Files\uDig\1.4.0\udig;.;C:\Windows\Sun\Java\bin;.....................................................................................

<<<<-- NO MORE ENTRIES IN THE LOG FILE-->>>>

-----Mensaje original-----
De: Mauricio Pazos [mailto:[hidden email]]
Enviado el: martes, 11 de marzo de 2014 18:17
Para: [hidden email]
CC: César Arriaga Egües
Asunto: Re: [udig-users] Adding PostGIS Sql view

Hi, maybe you have found a bug. Could you attach the log? It is available in :

Help > Submit Issue

Please, provide some details about your installation (udig version, operating
system)

cheers

--
Mauricio Pazos


On Saturday, March 08, 2014 02:39:02 PM César Arriaga Egües wrote:

> Dear friends.
>
> I have created a database view in Postgres/PostGIS based on two 1:1 related
> tables.
>
> create view cat_building_v
>   as select g.idbuilding, d.text, g.geom
>   from cat_building_data d inner join cat_building_geo g
>   on d.idbuilding = g.idbuilding;
>
> I am trying to add this view to a new map in uDig but the view is not even
> listed in the "add layer from Postgis" wizzard.
>
> I have been reading some posts of 2006 talking about the same issue, but in
> that time, it seem that the view could be listed in the same dialog.
>
> Also checked the PostGIS geometry_columns view in which both
> cat_building_geo TABLE and cat_building_v VIEW are returned with the same
> attributes.
>
> f_table_catalog f_table_schema  f_table_name          f_geometry_column
> coord_dimension srid    type TestDB            public
> cat_building_geo geom                 2               25830      POINT
> TestDB            public               cat_building_v   geom
>  2               25830      POINT
>
> The same view can be rendered in QGIS with the same connection parameters
> (user).
>
> Is there a way to render database views in uDig.
>
> Thanks in advance.
>
> César Arriaga.
>
> ________________________________
>
> AVISO SOBRE CONFIDENCIALIDAD: La información incluida en este mensaje es
> CONFIDENCIAL y de uso EXCLUSIVO a su FINALIDAD. Su posterior divulgación
> será responsabilidad de quien la realice
> _______________________________________________
> udig-users mailing list
> [hidden email]
> http://lists.refractions.net/mailman/listinfo/udig-users


________________________________

AVISO SOBRE CONFIDENCIALIDAD: La información incluida en este mensaje es CONFIDENCIAL y de uso EXCLUSIVO a su FINALIDAD. Su posterior divulgación será responsabilidad de quien la realice
_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users