| 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: | Whole Thread | Raw Message | 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
| 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 |