Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Open pgAdmin III and connect to your SDW as an Admin User and check the public schema for a layer_styles table. If it does not exist then open a SQL window and run the following:

Code Block
CREATE TABLE public.layer_styles

(
  id serial NOT NULL,
  f_table_catalog character varying,
  f_table_schema character varying,
  f_table_name character varying,
  f_geometry_column character varying,
  stylename character varying(30),
  styleqml xml,
  stylesld xml,
  useasdefault boolean,
  description text,
  "owner" character varying(30),
  ui xml,
  update_time timestamp without time zone DEFAULT now(),
  CONSTRAINT layer_styles_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.layer_styles OWNER TO "astun";
GRANT ALL ON TABLE public.layer_styles TO "astun";
GRANT SELECT, INSERT, DELETE, UPDATE ON TABLE public.layer_styles TO sdw_staff;
GRANT SELECT, UPDATE ON SEQUENCE public.layer_styles_id_seq TO sdw_staff;

...