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:[email protected]] Sent: Monday, August 30, 2010 11:40 PM To: Michael Andrew Babb Cc: [email protected] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] polygon overlay
Hi, I don't see any overlap between the polygon and the box in the following sql. Can anyone explain why it returns 't'? select polygon(path '((0,0),(10,10),(20,10),(10,0))') && polygon(box '((16,0),(17,1))'); ?column? -- t (1 row) Thanks, Gary -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
