tuanhoanganh <[EMAIL PROTECTED]> writes:
> I write script in Query of pgAdminIII
> ...
> In functions, I have a new function test. But when I choose "CREATE
> script" with function test the script change to
> -- Function: test(ud_stt_rec(24))
> -- DROP FUNCTION test(ud_stt_rec(24));
> CREATE OR
On 2/22/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> tuanhoanganh <[EMAIL PROTECTED]> writes:
> > ... But when I dump database and restore to 8.3 this function change to
>
> > CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
>
> It works as expected for me. Please provide a *complete* test case,
tuanhoanganh <[EMAIL PROTECTED]> writes:
> ... But when I dump database and restore to 8.3 this function change to
> CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
It works as expected for me. Please provide a *complete* test case,
including the specific dump and reload procedures you are
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 databa
