[Postgres-xc-general] HELP with MOODLE and Postgres-XC

[Afonso B. <aag...@gm...>]

Please, i'm very new in postgres-xc and I need help with
instlal moodle 2.5 with postgres-xc

here is the error message

Debug info: ERROR: duplicate key value violates unique constraint
"mdl_cont_id_pk"
DETAIL: Key (id)=(1) already exists.
INSERT INTO mdl_context (contextlevel,instanceid,depth,path)
VALUES($1,$2,$3,$4) RETURNING id
[array (
'contextlevel' => 50,
'instanceid' => '1',
'depth' => 0,
'path' => NULL,
)]

---------------------------------------------
and this are the tables that the system shows


--
-- Name: mdl_context; Type: TABLE; Schema: public; Owner: postgres;
Tablespace:
--

CREATE TABLE mdl_context (
    id bigint NOT NULL,
    contextlevel bigint DEFAULT 0 NOT NULL,
    instanceid bigint DEFAULT 0 NOT NULL,
    path character varying(255),
    depth smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.mdl_context OWNER TO postgres;

--
-- Name: mdl_cont_id_pk; Type: CONSTRAINT; Schema: public; Owner: postgres;
Tablespace:
--

ALTER TABLE ONLY mdl_context
    ADD CONSTRAINT mdl_cont_id_pk PRIMARY KEY (id);



--
-- Name: TABLE mdl_context; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE mdl_context IS 'one of these must be set';
-
-- Name: mdl_context_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE mdl_context_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mdl_context_id_seq OWNER TO postgres;

--
-- Name: mdl_context_id_seq; Type: SEQUENCE OWNED BY; Schema: public;
Owner: postgres
--

ALTER SEQUENCE mdl_context_id_seq OWNED BY mdl_context.id;


--
-- Name: mdl_context_temp; Type: TABLE; Schema: public; Owner: postgres;
Tablespace:
--

CREATE TABLE mdl_context_temp (
    id bigint NOT NULL,
    path character varying(255) DEFAULT ''::character varying NOT NULL,
    depth smallint NOT NULL
);


ALTER TABLE public.mdl_context_temp OWNER TO postgres;

--
-- Name: TABLE mdl_context_temp; Type: COMMENT; Schema: public; Owner:
postgres
--
COMMENT ON TABLE mdl_context_temp IS 'Used by build_context_path() in
upgrade and cron to keep context depths and paths in sync.';


Best Regards
Afonso Bione