I have function in PostgreSQL 8.2 CREATE OR REPLACE FUNCTION post_ctpxd(ud_stt_rec) RETURNS void AS $BODY$DECLARE ... BEGIN .... END $BODY$ LANGUAGE 'plpgsql' VOLATILE; My domain in 8.2 CREATE DOMAIN ud_stt_rec AS character(20) DEFAULT ''::bpchar NOT NULL; But when I dump database and restore to 8.3 this function change to CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24)) RETURNS void AS $BODY$DECLARE ... BEGIN ... END $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; My domain in 8.3 CREATE DOMAIN ud_stt_rec AS character(20) DEFAULT ''::bpchar; So when I run script CREATE OR REPLACE FUNCTION post_ctpt1 it have error ERROR: type modifier is not allowed for type "ud_stt_rec" ********** Error ********** ERROR: type modifier is not allowed for type "ud_stt_rec" SQL state: 42601 Please help me. Thank you very much. Tuan Hoang Anh hatuan05@xxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings