If it's empty space at the beginning it goes on for a long time. Can I send the table as an sql dump as an attachment with the list?? Bob-----Original Message----- From: Adrian Klaver
Sent: Friday, April 22, 2011 1:29 PM To: Bob Pawley Cc: pgsql-general@xxxxxxxxxxxxxx ; Scott Marlowe Subject: Re: Different views of remote server On Friday, April 22, 2011 12:52:28 pm Bob Pawley wrote:
Hi A little more research. I accessed the problem table as a remote connection using PGAdmin. I selected the cell that shows as being null and copied and pasted the contents into Word. The geom IS there.Using this method the geom is also present, but not visible, in the table Iam accessing as a local connection. This is the remote database which I dumped and then restored as a local. These fields are not only not visible but they return null when I do a simple select query. I could really do with some suggestions.
Still waiting for a description of the table and the exact data type you are using. Also are you sure it is really returning null and that you are not looking at empty space at the beginning of the record?
-- 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
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]