Function parameters change when update to 8.3

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

Responses

Browse pgsql-general by date

  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