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

[Purvis, Charlton]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 4706 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050503/0269487b/attachment.bin>