bug when creating/dropping function with a user defiend domain (adds size)

From: "Eric P(dot) Melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: bug when creating/dropping function with a user defiend domain (adds size)
Date: 2008-03-26 01:18:46
Message-ID: 00d301c88edf$574d3cf0$05e7b6d0$@melbardis@netkitsolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Melvin Davidson 2008-03-26 16:58:04 Count not updated with VACUUM ANALYZE
Previous Message Eric P. Melbardis 2008-03-26 00:54:30 bug when creating/dropping function with a user defiend domain (adds size)