[postgis-users] [?? Probable Spam] Re: Trouble seeinglistingtables

[Bistrais, Bob]

I do not have a geometry_columns table in the mapfile, but here is my
connection strings in the map file:

 

LAYER

  NAME 'MAINE'

 

  DATA "the_geom from Metwp100Poly USING SRID=26919 USING Unique gid"

  CONNECTION "user=myuser  password=mypassword dbname=postgistest
host=localhost port=5432"

  CONNECTIONTYPE postgis

  PROCESSING "CLOSE_CONNECTION=DEFER"

 

  STATUS on

  

    Projection

            "init=epsg:26919"   

    END

 

 

 

-Does this look correct?  I am still getting error messages.  Here is
the error from the debug log:

 

prepare_database(): Query error. Error declaring cursor: ERROR:
relation "metwp100poly" does not exist

LINE 1: ...lection(force_2d(the_geom)),'NDR'),gid::text from
Metwp100Po...

                                                             ^

 

With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from
Metwp100Poly WHERE the_geom && setSRID('BOX3D(134000
4692598.18523154,890900 5307401.81476846)'::BOX3D, 26919 )

 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Francisco Salas Rosette
Sent: Monday, February 13, 2012 5:09 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] [?? Probable Spam] Re: Trouble
seeinglistingtables

 

Bob, this is one example for connection in mapserver with postgis , in
DATA section do you put the selection. 

on the other hand, do you review in the geometry_columns table in public
scheme , if there exists you table?

 

the  geometry_columns table , describe projection, geometric columns ,
etc.

 

 

  LAYER

    CONNECTION "dbname=datosfg user=postgres password=postgres
host=localhost"

    CONNECTIONTYPE POSTGIS

    DATA "wkb_geometry from suelo USING SRID=4267001 USING Unique gid"

    METADATA

      "srid"              "4267001"

      "table_name"            " suelo"

      "cant_class_temat" "0"

      "field_list"    "gid, rugosidad, humedad, profundidad, suelo"

    END

    NAME "Suelos"

    STATUS ON

    TEMPLATE "ttt"

    TYPE POLYGON

    UNITS METERS

    CLASS

      NAME "Suelos"

      STYLE

        ANGLE 360

        COLOR 174 183 180

        OPACITY 100

        OUTLINECOLOR 35 80 65

        SYMBOL 0

      END

    END

  END

 

Francisco Salas 

 

De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] En nombre de
Bistrais, Bob
Enviado el: lunes, 13 de febrero de 2012 04:47 p.m.
Para: PostGIS Users Discussion
Asunto: [?? Probable Spam] Re: [postgis-users] Trouble seeinglisting
tables

 

Hello Francisco,

 

I loaded the data using the PostGIS Shapefile and DBF Loader.  The table
has a column called the_geom.  I don't see any column for the SRS or
projection.

 

I made some progress- I forgot to put quotes on my table name, so my
select command should be:

SELECT * from "mytable";

-and that works correctly.

 

But, I am still not able to see my layer in MapServer.  I have posted to
the MapServer list as well, to see if anyone can help.  I get a
MapServer error that says:

ERROR: relation "mytable" does not exist...

 

 

 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Francisco Salas Rosette
Sent: Monday, February 13, 2012 4:44 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] [!! SPAM] Trouble seeinglisting tables

 

Bob, do you review if there exists mytable in the geometry_columns
table?

How do you loaded this table?

 

Francisco salas 

 

 

De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] En nombre de
Bistrais, Bob
Enviado el: lunes, 13 de febrero de 2012 03:58 p.m.
Para: PostGIS Users Discussion
Asunto: [!! SPAM] [postgis-users] Trouble seeinglisting tables

 

I am having trouble on a pretty basic level.  I loaded a couple
shapefiles into PostGIS.  I can see that they successfully loaded when I
use pgAdmin.  But when I go to command line, I have trouble.  I can do a
\d command and see the tables exist in the database.  But if I do a
select * from mytable; I get an errer, "relation "mytable" does not
exist.  What am I doing wrong here?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120213/1ca211a5/attachment.html>