[Qgis-developer] Postgresql layers not displaying?

[Martin Dobias]

On 10/2/07, icosa atropa <icos.atropa at gmail.com> wrote:
>
> [...]
> 488: (select) Binary cursor: declare qgisf binary cursor for select
> "gid",asbinary("the_geom",'NDR') as qgs_feature_geometry from
> "public"."wellpts"
> Debug: /home/xian/dev/cpp/qgis/src/providers/postgres/qgspostgresprovider.cpp:
> 530: (select) Selecting features using: declare qgisf binary cursor
> for select "gid",asbinary("the_geom",'NDR') as qgs_feature_geometry
> from "public"."wellpts" where the_geom &&
> setsrid('BOX3D(-107.4538741064854719 33.8069458007812003,
> -106.1066269921475254 35.0084381103515980)'::box3d,-1) and ("wellname"
>  ~* 'M*')
> Debug: /home/xian/dev/cpp/qgis/src/providers/postgres/qgspostgresprovider.cpp:
> 361: (getNextFeature) End of features
> Debug: /home/xian/dev/cpp/qgis/src/core/qgsvectorlayer.cpp: 832:
> (draw) Total features processed is 0

>From this piece of debug output it seems like there are no features
that would correspond the given rectangle (-107.4538 33.8069,
-106.10662 35.0084) and the additional constraint you must have added:
"wellname" ~* 'M*'

You can rerun the query in some tool...

Martin