[postgis-users] query results not returning: unique problems

[Graeme Leeming]

Charlton,

Not sure if this is the problem, but your query returns two columns with the
same name:

wind_speed as wind_speed_mps
normalized_wind_speed as wind_speed_mps

Graeme Leeming
Refractions Research Inc.

"Purvis, Charlton" wrote:

> Hi, folks:
>
> Paul, you may or may not remember the 1st time you saved my hide when my
> query results all of a sudden disappeared.  And it turned out to be because
> my OID's grew too big.  I slapped my own unique sequence on there, and all
> was well.
>
> Unfortunately, the symptom has returned for only one table inside this DB.
> It was possible that my new sequence had gotten unwieldy, so I reset the
> sequence to start at 1 and then COPY-ed in a fresh table.  I double checked,
> and my sequence max is reasonable < 1,000,000.  But I still can't see any
> results.  I'm talking WFS here, and I am positive that data should be
> returning.  I can get a WMS image from a similar query, but no WFS.  That's
> what made me suspicious about the seq.
>
> Does anyone see any glaring problems below:
>     DATA "the_geom from (select station_id, time_stamp, label_z, wind_speed
> as wind_speed_mps, wind_speed_knots, wind_speed_mph, normalized_wind_speed
> as wind_speed_mps, normalized_wind_speed_knots, normalized_wind_speed_mph,
> wind_from_direction, wind_from_direction_compass, can_be_normalized,
> the_geom, seq from wind_prod) as foo USING UNIQUE seq USING SRID=-1"
>
> I've done a fix_geometry_columns();.  Is there anything else I can do to
> tell PostGIS or MapServer that, hey, listen up, these are unique, dangit!?
>
> postgresql-7.4.1 postgis-0.8.1
>
> Thanks,
>
> Charlton
>
>
>
>
> Charlton Purvis
> (803) 777-8858 : voice
> (803) 777-3935 : fax
> cpurvis at sc.edu
>
> Baruch Institute
> University of South Carolina
> Columbia, SC 29208
>
>   ------------------------------------------------------------------------
>
>    Part 1.2    Type: application/ms-tnef
>            Encoding: base64
>
>   ------------------------------------------------------------------------
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users