Displaying 1 result from an estimated 1 matches for "quota_pkey".
2009 Jul 20
1
Problem with quota-dict
...dbname=mail user=mail password=dovecot-passwort
table = quota
select_field = current
where_field = path
username_field = username
My database table:
CREATE TABLE quota
(
username character varying(255) NOT NULL,
path character varying(100) NOT NULL,
"current" integer,
CONSTRAINT quota_pkey PRIMARY KEY (username, path)
)
WITH (OIDS=FALSE);
ALTER TABLE quota OWNER TO mail;
-- Trigger: mergequota on quota
-- DROP TRIGGER mergequota ON quota;
CREATE TRIGGER mergequota
BEFORE INSERT
ON quota
FOR EACH ROW
EXECUTE PROCEDURE merge_quota();
connect = host=localhost dbname=mail user...