[pgadmin-support] bug when creating/dropping function with a user defiend domain (adds size)

[Eric P. Melbardis]

Retry: having issue with e-mail.

 

 

hi when i execute the following script using pgadmin query tool:

 

windows xp, sp2

pgadmin 1.8.2 as installed whith postgres binary 8.3.1

 

 

 

--------------------------------

 

CREATE DOMAIN "dt_0" AS varchar(32)

                NULL;

 

CREATE DOMAIN "dt_1" AS varchar

                NULL;

 

 

 

CREATE FUNCTION "x1" (IN name dt_0, IN description dt_1)

RETURNS integer 

AS $$

SELECT 0;

$$

LANGUAGE SQL

IMMUTABLE

RETURNS NULL ON NULL INPUT;

 

 

---------------------------

 

 

when i look at the function definition using pgadmin it looks like this:

 

-- Function: x1(dt_0(36), dt_1)

 

-- DROP FUNCTION x1(dt_0(36), dt_1);

 

CREATE OR REPLACE FUNCTION x1("name" dt_0(36), description dt_1)

  RETURNS integer AS

$BODY$

SELECT 0;

$BODY$

  LANGUAGE 'sql' IMMUTABLE STRICT

  COST 100;

ALTER FUNCTION x1(dt_0(36), dt_1) OWNER TO postgres;

 

--------------------------

 

if i try to delete it: i get:

 

an error has occured: tyep modifier is not allowed for type "dt_0"

 

why is the (36) there????

 

 

regards