[ms4w-users] RE: failed to modify or delete or create my postgis layers in FIST

[Ilias Petrou]

I tried to put the public schema in my data in the
mapfile and the result is thatthe layers not even
appear now . Before inserting the  public(which IS the
schema that my CITIES and coast layer are under) i
could watch my coast and cities layers and zoom and
query and measure distances in FIST. 
Below is my mapfile without using ths public schema

MAP
  NAME "lesvo"
  STATUS ON
  EXTENT 395671.8775452 4306847.90554 469213.1224548
4365767.09446 
  SIZE 400 300
  IMAGETYPE PNG
  IMAGECOLOR 0 0 255
  UNITS METERS
  WEB
    IMAGEPATH "c:\ms4w\apps\fist\htdocs\tmp\"
    IMAGEURL "/tmp/"
  END
  
      QUERYMAP
		STYLE HILITE
		COLOR 255 255 0
	END

	OUTPUTFORMAT
	  NAME png
	  DRIVER "GD/PNG"
	  MIMETYPE "image/png"
	  IMAGEMODE RGB
	  EXTENSION "png"
	END

	# ----- MAP ELEMENTS -------------------
	# --------------------------------------	

	PROJECTION
	  "init=epsg:32635"
	END

	LEGEND
		STATUS ON
	END
	
	SCALEBAR
		STATUS on
		UNITS kilometers
		INTERVALS 3
		SIZE 150 5
		OUTLINECOLOR 0 0 0
		LABEL
			SIZE small
		END
	END

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

 
  LAYER
    NAME "coast"
    STATUS ON
    DATA "the_geom from coast"
    TYPE POLYGON
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=postgres password=iliaskoz
dbname=peirama host=localhost port=5432"
    CLASSITEM "gid"
    UNITS METERS
    SIZEUNITS PIXELS
    TOLERANCE 0
    TOLERANCEUNITS PIXELS
    CLASS
      NAME "gid"
      STYLE
        SYMBOL "circle"
        COLOR 198 87 56
        BACKGROUNDCOLOR 198 87 56
        SIZE 0
        MINSIZE 1
        MAXSIZE 100
      END
    END
  END
LAYER
    NAME "cities"
    STATUS ON
    DATA "the_geom cities"
    TYPE POINT
    TEMPLATE "nepas.html" 
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=postgres password=iliaskoz
dbname=peirama host=localhost port=5432"
    CLASSITEM "cities_"
    UNITS METERS
    SIZEUNITS PIXELS
    TOLERANCE 0
    TOLERANCEUNITS PIXELS
    CLASS
      NAME "cities_"
      STYLE
        SYMBOL "circle"
        COLOR 120 20 20
        SIZE 8
        MINSIZE 1
        MAXSIZE 100
      END
    END
    PROJECTION
	 "init=epsg:32635"
    END    
 END
END

--- Aaron Koning <aaronkoning at gmail.com> wrote:

> I bet your problem has to do with the DATA variable
> in your mapfile not
> containing a schema name. See post:
>
http://www.freelists.org/archives/fist-users/03-2006/msg00021.html
> 
> Thanks,
> Aaron
> 
> On 3/19/06, Ilias Petrou <iliaskoz at yahoo.com> wrote:
> >
> > hi i have installed ms4w and then install FIST.
> > when I am trying to modify or delete or create new
> > features of my postgis layer( the active one)
> nothing
> > happen. The user i use in the connection string is
> the
> > owner of the postgis table so normally he does
> have
> > the right to modify the tables.
> > Note that i added the
> > " <context>
> >               <modes>
> >                        <mode>edit</mode>
> >                </modes>
> >              </context> "
> > in the layer config file  under the layer i want.
> >
> > So for example when i want to digitize a new point
> it
> > shows the
> > message "Accept the location of the point." but
> when i
> > choose the button  "NEXT " nothing happens!!!
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> > _______________________________________________
> > ms4w-users mailing list
> > ms4w-users at lists.maptools.org
> >
>
http://lists.maptools.org/mailman/listinfo/ms4w-users
> >
> 
> 
> 
> --
> +--------------------------------------------
> |  Aaron Koning
> |  Information Technologist
> |  Prince George, BC, Canada.
> +--------------------------------------------
> |  http://datashare.gis.unbc.ca/fist/
> |  http://datashare.gis.unbc.ca/gctp-js/
> +--------------------------------------------
> > _______________________________________________
> ms4w-users mailing list
> ms4w-users at lists.maptools.org
>
http://lists.maptools.org/mailman/listinfo/ms4w-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com