| From: | "epm666" <epm666(at)gmail(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 00:34:19 |
| Message-ID: | 007001c88ed9$21a2e470$64e8ad50$@com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric P. Melbardis | 2008-03-26 00:36:02 | test |
| Previous Message | Guillaume Lelarge | 2008-03-25 12:13:22 | Re: operator classes in pgAdmin |