From: | "Dave Page" <dpage(at)pgadmin(dot)org> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "eric melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4056: problem creating function with domain argument |
Date: | 2008-03-27 15:52:03 |
Message-ID: | 937d27e10803270852s1529f89ep34b1ed850fb4039a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Mar 25, 2008 at 5:37 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "eric melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com> writes:
> > Description: problem creating function with domain argument
>
> AFAICT this example works fine in psql. You need to take it up
> on the pgAdmin mailing list. It looks to me like pgAdmin is mistakenly
> thinking that a domain has type modifiers.
pgAdmin is using format_type() with a query like:
postgres=# SELECT oid, format_type(oid, typtypmod) AS typname FROM
pg_type where oid = 'dt_0'::regtype;
oid | typname
-------+----------
35130 | dt_0(36)
(1 row)
I would expect it to format the type appropriately.
--
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-03-27 16:07:43 | Re: Extra empty lines PGv8.3.1 |
Previous Message | Eugen.Konkov | 2008-03-27 15:51:58 | Extra empty lines PGv8.3.1 |