On Wednesday, April 20, 2011 11:09:59 am Bob Pawley wrote: > Hi > > This is probably going to turn out to be me doing something stupid, but- > > I have two computers, one of which I use as a remote server for my > database. > > When I connect to the remote database through my interface there are errors > that suggest a problem with the data in one of the tables. > > Using PgAdmin to view the remote table there is indeed some information > missing (5 out of 16 geoms). > > When I use the PGAdmin on the remote computer, using a local connection, > this information is not missing it is intact. > > I donât think it is a PgAdmin problem because when I do a âselect the_geomâ > as a remote query the information is missing where it is not missing the > PgAdmin on the other computer as a local query. > > Also connecting to the remote DB using Quantum GIS shows the âmissingâ > information as being present and normal. > > I have also checked with a server display app and the appropriate number of > servers are present (only one present on the remote computer). > > Iâve run out of ideas - Would anyone have any thoughts of what might be > going on??? What is the schema for the table? What exactly is the data and do the 5 'missing' data differ markedly from the other data? > > Bob -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
