BUG #4056: problem creating function with domain argument

From: "eric melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4056: problem creating function with domain argument
Date: 2008-03-25 00:53:08
Message-ID: 200803250053.m2P0r8cf081165@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4056
Logged by: eric melbardis
Email address: eric(dot)melbardis(at)netkitsolutions(dot)com
PostgreSQL version: 8.3.1
Operating system: windows xp sp 2
Description: problem creating function with domain argument
Details:

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

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

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2008-03-25 02:11:31 Re: postgresql in FreeBSD jails: proposal
Previous Message Bruce Momjian 2008-03-25 00:49:04 Re: BUG #3855: backend sends corrupted data onEHOSTDOWNerror