Re: Weird quirk with pg_dump of complex types

Jeff Davis wrote:
> On Fri, 2009-02-27 at 01:24 -0500, Tom Lane wrote:
>> Are you entirely sure that they don't?
>
> Oh, you're right, of course:
>
> postgres=# create type public.mytype as (i int);
> CREATE TYPE
> postgres=# create type public.mytype2 as (j mytype);
> CREATE TYPE
>
> -- pg_dump output:
> CREATE TYPE mytype2 AS (
>         j mytype
> );

Really?

Ok, I'll have to work up a reproduceable case, because I'm definitely
getting the "public" qualification in the create type.

--Josh