[postgis-users] gone are my query results

Charlton Purvis cpurvis at asg.sc.edu
Sat May 1 14:46:35 PDT 2004


Hi, folks:
 
Bizarre and unnerving problem here.
 
Up until last night, mapping was fine and point-query was fine.  Now it appears that the mapping is still great, but the point query and WFS are toast.  I don't get any errors in pgsql.log or php.log.  I get . . . nothing.  Even going mapserv cgi query returns empty for a query I know should work.
 
Maybe I'm being taught a lesson.  In a separate database, I noticed that addgeometrycolumn was taking too long -- I create about 400 smaller tables per day.  So I commented out fix_geometry_columns(); from the addgeometrycolumn function and did it once I had finished creating all my new tables.  So am I paying the price?  Has this corrupted this database as well as my other?
 
If all this is OID stuff, is there any way to refresh all OID's?
 
Restarted . . . yes.  VACUUM and ANALYZE'd . . . yes.
 
Thanks,
 
Charlton
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4130 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040501/210970e8/attachment.bin>


More information about the postgis-users mailing list