BUG #4056: problem creating function with domain argument
От | eric melbardis |
---|---|
Тема | BUG #4056: problem creating function with domain argument |
Дата | |
Msg-id | 200803250053.m2P0r8cf081165@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4056: problem creating function with domain argument
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4056 Logged by: eric melbardis Email address: eric.melbardis@netkitsolutions.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
В списке pgsql-bugs по дате отправления: