Re: Different views of remote server - Mailing list pgsql-general

From Bob Pawley
Subject Re: Different views of remote server
Date
Msg-id 491DE03AA3404325893F00503871C3A3@BobPC
Whole thread Raw
In response to Re: Different views of remote server  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Different views of remote server
List pgsql-general
Hi Adrian

I looked at the table in JEdit. The binary strings for the missing fields
are considerably longer than the others.

What limiting factor have I probably exceeded??

Bob

-----Original Message-----
From: Adrian Klaver
Sent: Wednesday, April 20, 2011 4:14 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Different views of remote server

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@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Installing PGDG on a fresh CentOS 5.6
Next
From: Karsten Hilbert
Date:
Subject: Re: problem with parent/child table and FKs