Search Postgresql Archives

Function parameters change when update to 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux