\connect - postgres
DROP FUNCTION dupecheck();
DROP TRIGGER dupetrigger ON comment;
CREATE FUNCTION dupecheck() RETURNS OPAQUE AS '/path/to/dupetrigger.so' LANGUAGE 'C';
CREATE TRIGGER dupetrigger BEFORE INSERT OR UPDATE ON comment FOR EACH ROW EXECUTE PROCEDURE dupecheck();
CREATE INDEX comment_checksum_index on comment (checksum);