[SQL] PostGres Tables in ArcSDE and ArcCatalog.
Hi All, I am using PostGRES 8.3 in conjunction with ESRI's ArcSDE. ArcSDE allows the storage of spatial data inside of an PostGRES database. One of the programs bundled with ESRI's GIS suite is ArcCatalog. ArcCatalog is a spatial data manager. It is possible to browse and analyze the contents of PostGRES databases using ArcCatalog. In my PostGRES database, I have a table called SF30001. I can fully interact with the table using PSQL and pgAdmin III. However, I cannot interact with the table at all using ArcCatalog. Full interactivity needs to happen with ArcCatalog because the majority of the users of the PostGRES database will be using ArcCatalog to access data in the PostGRES database. 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. I suspect that what I am running into is an ArcSDE configuration setting but I am not sure which one. I am not ready to rule out the issue as a PostGRES issue either. I'm currently pouring over configuration settings and how-to documents, but I wonder if anybody has any recommendations on how to gain full interactivity with the original table in ArcCatalog. Thanks, Mike
Re: [SQL] 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.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 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
