| From: | tuanhoanganh <hatuan05(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Function parameters change when update to 8.3 |
| Date: | 2008-02-22 04:48:29 |
| Message-ID: | c235f61d0802212048l22505b7cx7941a02d26ef36e0@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-02-22 05:36:42 | Re: Function parameters change when update to 8.3 |
| Previous Message | Scott Marlowe | 2008-02-22 04:31:34 | Re: need some help on figuring out how to write a query |