Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

 

 

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group