Postgis and PostgreSQL Problem

[Frank Fica]

Hi Steve,

Here is my map definition:

I have also tried DATA "wkb_geometry from ciud_guate_calles"

MAP
  IMAGETYPE PNG
  EXTENT -90.587129 14.541685 -90.433474 14.685685

  SIZE 640 480
  CONFIG CPL_DEBUG "ON"

  SYMBOL
   NAME "circle"
   TYPE ELLIPSE
   POINTS
    1 1
   END
   FILLED TRUE
  END


  LAYER
   NAME "calles"
   TYPE LINE
   STATUS ON
   DEBUG ON
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=xxx.xxx.xxx.xxx port=5432 dbname=xxx user=xxx  password=xxx"
   DATA "wkb_geometry from (SELECT * FROM ciud_guate_calles) as foo using unique ogc_fid using
SRID=32767"
   CLASS
      NAME "calles"
      STYLE
       COLOR 255 255 255
      END
   END
 END

LAYER
    NAME sorento
    TYPE POINT
    SIZEUNITS PIXELS
    TOLERANCE 0
    UNITS METERS
    CONNECTIONTYPE OGR
    CONNECTION "virtual.ovf"
    DATA "sorento"
    STATUS DEFAULT
    DEBUG ON
    CLASS
     NAME sorento
     STYLE
      SYMBOL 'circle'
      SIZE 4
      COLOR 255 0 0
     END
    END
 END
END


>Frank,
>
>Can you post your layer definition so we can look at that.
>
>Thanks,
  > -Steve W.