Re: [RCU] db problem with address book

Juerg Reimann skrev den 19-12-2012 21:47:

Hi Benny

Thanks, it didn't work out...the address book is still not working. This is my current db layout: http://pastie.org/5554369

--- 1 2012-12-19 22:54:41.000000000 +0100 +++ postgres.initial.sql 2012-12-19 22:54:25.000000000 +0100 @@ -1,11 +1,12 @@ CREATE TABLE contacts (

• contact_id integer DEFAULT nextval(('contact_ids'::text)::regclass)

NOT NULL,

• user_id integer NOT NULL,

• contact_id integer DEFAULT nextval('contact_ids'::text) PRIMARY KEY,
• user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE

ON UPDATE CASCADE, changed timestamp with time zone DEFAULT now() NOT NULL, del smallint DEFAULT 0 NOT NULL,

• name character varying(128) DEFAULT ''::character varying NOT NULL,
• email text DEFAULT ''::character varying NOT NULL,
• firstname character varying(128) DEFAULT ''::character varying NOT

NULL,

• surname character varying(128) DEFAULT ''::character varying NOT

NULL,

• vcard text

• name varchar(128) DEFAULT '' NOT NULL,
• email text DEFAULT '' NOT NULL,
• firstname varchar(128) DEFAULT '' NOT NULL,
• surname varchar(128) DEFAULT '' NOT NULL,
• vcard text,
• words text );

there is a diffrent to what is in 0.8.1, have you updated layout ?