Re: [SQL] PostGres Tables in ArcSDE and ArcCatalog.

2010-08-31 Thread Scott Marlowe
On Mon, Aug 30, 2010 at 1:31 PM, Michael Andrew Babb ba...@uw.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.

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


Re: [SQL] PostGres Tables in ArcSDE and ArcCatalog.

2010-08-31 Thread Michael Andrew Babb
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.marl...@gmail.com] 
Sent: Monday, August 30, 2010 11:40 PM
To: Michael Andrew Babb
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] PostGres Tables in ArcSDE and ArcCatalog.

On Mon, Aug 30, 2010 at 1:31 PM, Michael Andrew Babb ba...@uw.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.

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