Thread: Error if CREATE DOMAIN used

Error if CREATE DOMAIN used

From
narkeassocia@sancharnet.in
Date:
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
 
Thanks in advance
Ajay Narke
Narke Associates
F-2, G.N. Chambers, Kolekar Tickty,
B Ward, Kolhapur 416012. INDIA
Phone# +91-231-2621701 /  +91-94224-13843
web: www.narkeassociates.com
Attachment

Re: Error if CREATE DOMAIN used

From
"Dave Page"
Date:
 
-----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
 
Hi,
 
This problem is fixed in the 1.5.60 beta release we made yesterday - you can download it from http://www.pgadmin.org/downloads.
 
Regards, Dave.