the OID field is for sure required, as it is used as the index to the
records. For what strange reasons whatsoever the Postgres developers removed
the default creation of an OID field in version 8.1. For your tables you had
to create them with 'WITH OID' at the end.
armin
>
> Well Ive tried the WHERE clause and that worked I also tried removing the
> group line with no success - now after delving thru a bit more and
> exposing
> the query in dumpPGQueryResults I have found that an uppercase FROM in my
> mapfile was causing problems.
>
> I have removed that and now i get 'no results'
>
> the next problem i have found is in squery.php::dumpPGQueryResults where
> the
> filter is added you have the code
>
> // Apply already existing filter on layer
> $pg_filter = str_replace('"', '', $this->qLayer->getFilter());
> if (strlen(trim($pg_filter)) > 2 ) {
> $queryStr .= " AND $pg_filter ";
> }
> I changed the if clause to
>
> if (strlen(trim($pg_filter)) > 2 && $pg_filter != "(null)")
>
> because I have no filter defined on that layer and that was what was being
> returned by $this->qLayer->getFilter()
>
> now I still get no results because I have no column "oid" (im new to
> postgis) when i removed it from the query i get results but they are
> dodgy
> (not the right coordinates).
>
> So next I am going to determine whether its because oid is required or
> because im using DD for units or some other reason.
>
--
Echte DSL-Flatrate dauerhaft f?r 0,- Euro*!
"Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl
