Makes sense. Thinking in terms of the 3 levels of a DBMS (view/logical/physical), the representation of data types shouldn't vary from OS to OS, it should be handled by the database/client library/ODBC driver itself.
On the upside, at least you didn't have to go around chasing queries and look for bugs in a vendor's code. ronnie On Sat, Jan 8, 2011 at 7:12 PM, Byron Como <[email protected]> wrote: > The primary key on a table in the restored data was missing. I manually > recreated it and am back in business. This was just one of several problems > I had to sort through in the upgrade from XP to 7. Finally resolved all > issues. Glad I don't do tech support for a living. Pretty nerve-wracking. > *whew* > > On 1/8/2011 1:41 PM, Byron Como wrote: > > QuantumGIS relies on several dispersed software technologies to function > properly. Probably one of them isn't designed to work on Windows 7 64bit. I > was trying to get more memory to work with. Wasted my time and money I > guess. > > On 1/8/2011 1:35 PM, Ronnie Gilkey wrote: > > I don't have any experience with the GIS systems you're using; I've also > never experienced an issue like that. > > From a troubleshooting standpoint, I would double check the db to ensure > that any keys and sequences were generated properly and with the right > permissions. If that all looks OK I would debug the queries the GIS > software is sending to the system to see if that will provide any clues as > to why the columns are missing. > > Hope that helps, > > ronnie > > On Sat, Jan 8, 2011 at 1:24 PM, Byron Como <[email protected]> wrote: > >> I'm using 8.4 with spatial extensions to PostGIS. Several times I had to >> restore data on a Windows XP machine with no problems. Today, I'm restoring >> my data to a new Windows 7 setup. When I get my data into the QuantumGIS >> software the primary key column is missing. Everything seems ok in pgAdmin; >> the columns are all there. Any thoughts? >> >> _______________________________________________ >> General mailing list >> [email protected] >> http://brlug.net/mailman/listinfo/general_brlug.net >> >> > > _______________________________________________ > General mailing > [email protected]http://brlug.net/mailman/listinfo/general_brlug.net > > > > _______________________________________________ > General mailing > [email protected]http://brlug.net/mailman/listinfo/general_brlug.net > > > > _______________________________________________ > General mailing list > [email protected] > http://brlug.net/mailman/listinfo/general_brlug.net > >
_______________________________________________ General mailing list [email protected] http://brlug.net/mailman/listinfo/general_brlug.net
