Hi diatonicman,
Thanks for your response. I've been busy porting the schema from HSQL to PostgreSQL. I've almost finished rewriting the classes from the org.springframework.security.acls.jdbc package to use PostgreSQL... It's just booted under Tomcat for the first time without error 
The PostgreSQL setup script I've used is:
Code:
DROP TABLE IF EXISTS acl_sid CASCADE;
CREATE TABLE acl_sid
(
id serial PRIMARY KEY,
principal boolean NOT NULL,
sid character varying NOT NULL,
CONSTRAINT unique_uk_1 UNIQUE (sid, principal)
)
WITHOUT OIDS;
ALTER TABLE acl_sid OWNER TO securecontacts;
DROP TABLE IF EXISTS acl_class CASCADE;
CREATE TABLE acl_class
(
id serial PRIMARY KEY,
class character varying NOT NULL,
CONSTRAINT unique_uk_2 UNIQUE (class)
)
WITHOUT OIDS;
ALTER TABLE acl_class OWNER TO securecontacts;
DROP TABLE IF EXISTS acl_object_identity CASCADE;
CREATE TABLE acl_object_identity
(
id serial PRIMARY KEY,
object_id_class bigint NOT NULL,
object_id_identity bigint NOT NULL,
parent_object bigint,
owner_sid bigint,
entries_inheriting boolean NOT NULL,
CONSTRAINT unique_uk_3 UNIQUE (object_id_class, object_id_identity),
CONSTRAINT foreign_fk_1 FOREIGN KEY (parent_object) REFERENCES acl_object_identity (id),
CONSTRAINT foreign_fk_2 FOREIGN KEY (object_id_class) REFERENCES acl_class (id),
CONSTRAINT foreign_fk_3 FOREIGN KEY (owner_sid) REFERENCES acl_sid (id)
)
WITHOUT OIDS;
ALTER TABLE acl_object_identity OWNER TO securecontacts;
DROP TABLE IF EXISTS acl_entry CASCADE;
CREATE TABLE acl_entry
(
id serial PRIMARY KEY,
acl_object_identity bigint NOT NULL,
ace_order int NOT NULL,
sid bigint NOT NULL,
mask integer NOT NULL,
granting boolean NOT NULL,
audit_success boolean NOT NULL,
audit_failure boolean NOT NULL,
CONSTRAINT unique_uk_4 UNIQUE (acl_object_identity, ace_order),
CONSTRAINT foreign_fk_4 FOREIGN KEY (acl_object_identity) REFERENCES acl_object_identity (id),
CONSTRAINT foreign_fk_5 FOREIGN KEY (sid) REFERENCES acl_sid (id)
)
WITHOUT OIDS;
ALTER TABLE acl_entry OWNER TO securecontacts;
DROP TABLE IF EXISTS users CASCADE;
CREATE TABLE users
(
username character varying NOT NULL PRIMARY KEY,
password character varying NOT NULL,
enabled boolean NOT NULL
)
WITHOUT OIDS;
ALTER TABLE users OWNER TO securecontacts;
DROP TABLE IF EXISTS authorities CASCADE;
CREATE TABLE authorities
(
username character varying NOT NULL,
authority character varying NOT NULL,
CONSTRAINT fk_authorities_users FOREIGN KEY(username) REFERENCES users (username)
)
WITHOUT OIDS;
ALTER TABLE authorities OWNER TO securecontacts;
DROP INDEX IF EXISTS ix_auth_username CASCADE;
CREATE UNIQUE INDEX ix_auth_username ON authorities
(
username,
authority
);
DROP TABLE IF EXISTS contacts CASCADE;
CREATE TABLE contacts
(
id serial PRIMARY KEY,
contact_name character varying NOT NULL,
email character varying NOT NULL
)
WITHOUT OIDS;
ALTER TABLE contacts OWNER TO securecontacts;
I needed to change the SQL in JdbcMutableAclService and BasicLookupStrategy. I'll post the code for JdbcMutableAclService and BasicLookupStrategy once I've debugged a few remaining runtime issues 
Thanks again.
Craig
New ACL Module
Originally Posted by diatonicman
