Thread: Re: [pgadmin-support] Schemas causing problems :(

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 27 July 2004 16:16
> To: Dave Page
> Cc: Vitaly Belman; pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] [pgadmin-support] Schemas
> causing problems :(
>
> Complicated.
> Before trying to suppress the schema, I'm checking for any
> duplicate type names now. If so, schema is always emitted. In
> your sample:
> pg_catalog.text and public.text.

OK, that should work as well. Probably safer too I guess, though it is
vaguely possible that a schema name be unnecessarily included - a small
price to pay.

/D

Dave Page wrote:

>>Before trying to suppress the schema, I'm checking for any
>>duplicate type names now. If so, schema is always emitted. In
>>your sample:
>>pg_catalog.text and public.text.
>
>
> OK, that should work as well. Probably safer too I guess, though it is
> vaguely possible that a schema name be unnecessarily included - a small
> price to pay.

IMHO even desirable, because in the presence of more types over
different schemas it makes things clearer.

Regards,
Andreas