Обсуждение: error with domains

After creating a new schema and a domain in it, pgAdmin is unable to
display the schema. The code used to create the schema in psql:
jochemd=> select version();
                                version
---------------------------------------------------------------------
  PostgreSQL 7.3.1 on i386-unknown-openbsd3.2, compiled by GCC 2.95.3
(1 row)
jochemd=> CREATE SCHEMA information_schema;
CREATE SCHEMA
jochemd=> GRANT USAGE ON SCHEMA information_schema TO PUBLIC;
GRANT
jochemd=> SET search_path TO information_schema;
SET
jochemd=> CREATE DOMAIN cardinal_number AS integer;
CREATE DOMAIN

In pgAdmin when browsing the information_schema:
An error has occured in pgAdmin II:Main.tvNamespace:

Number: 13
Description: Type mismatch

I'm using pgAdmin version 1.4.12

Jochem

Hi Jochem,

Sorry for not getting back to you sooner. I've looked at this and cannot
reproduce the error you are seeing. Can you supply me with a 'Full
Debug' pgAdmin log plese?

Regards, Dave.

> -----Original Message-----
> From: Jochem van Dieten [mailto:jochemd@oli.tudelft.nl]
> Sent: 04 January 2003 22:45
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] error with domains
>
>
> After creating a new schema and a domain in it, pgAdmin is unable to
> display the schema. The code used to create the schema in psql:
> jochemd=> select version();
>                                 version
> ---------------------------------------------------------------------
>   PostgreSQL 7.3.1 on i386-unknown-openbsd3.2, compiled by GCC 2.95.3
> (1 row)
> jochemd=> CREATE SCHEMA information_schema;
> CREATE SCHEMA
> jochemd=> GRANT USAGE ON SCHEMA information_schema TO PUBLIC;
> GRANT
> jochemd=> SET search_path TO information_schema;
> SET
> jochemd=> CREATE DOMAIN cardinal_number AS integer;
> CREATE DOMAIN
>
> In pgAdmin when browsing the information_schema:
> An error has occured in pgAdmin II:Main.tvNamespace:
>
> Number: 13
> Description: Type mismatch
>
> I'm using pgAdmin version 1.4.12
>
> Jochem
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>

Dave Page wrote:
>
> This should now be fixed. Please update your pgSchema.dll file from the
> binaries folder on http://cvs.pgadmin.org/.

It works now, thanx.

Jochem