Re: PostGres Tables in ArcSDE and ArcCatalog.

Hi Scott,

Of all things, ArcSDE does not like tables with names consisting of mixed case letters. In addition, ArcSDE does not like field names consisting of mixed case letters.

I changed the case of the field names and table names to all lowercase and ArcCatalog could see the tables just fine. However, PostGRES can interact with tables with mixed case letters just fine.

Thanks,

Mike

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Monday, August 30, 2010 11:40 PM
To: Michael Andrew Babb
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] PostGres Tables in ArcSDE and ArcCatalog.

On Mon, Aug 30, 2010 at 1:31 PM, Michael Andrew Babb <babbm(at)uw(dot)edu> wrote:
> Hi All,
> If I execute a make table query along the lines of "select * into
> SF30001_test from SF30001" I can interact with the table in ArcCatalog just
> fine.

what do
\z SF30001
\z SF30001_test
say about the permissions on the two tables?
--
To understand recursion, one must first understand recursion.