Thread: Error if CREATE DOMAIN used

-----Original Message-----
From: narkeassocia@sancharnet.in [mailto:narkeassocia@sancharnet.in]
Sent: 19 May 2003 08:06
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Error if CREATE DOMAIN used

Hi,

 

I have encountered a bug with pgAdmin II 1.4.12 and PostgreSQL 7.3

 

Step 1: (I create a domain)

    CREATE DOMAIN amount AS float DEFAULT 0 CONSTRAINT amount_tc NOT NULL

 

Step 2: (I use the above domain in a table as a column type)

    CREATE TABLE test (

      id int4,

      amount amount

)

Step 3: (I fire up pgAdmin II and when I click down to 'public' schema, I get following error message)

 

An error has occured in pgAdmin II:frmmain.tvNamespace

 

Number: 13

Description: Type mismatch