Re: BUG #4056: problem creating function with domain argument

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