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: | Raw Message | Whole Thread | 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 |