Postgres Pro
Downloads
Home   >   mailing lists

Error if CREATE DOMAIN used - Mailing list pgadmin-support

From narkeassocia@sancharnet.in
Subject Error if CREATE DOMAIN used
Date
Msg-id 000901c31dd5$1cffedc0$0201a8c0@win2kws2
Whole thread Raw
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: ENCODING (Unicode)
Next
From: Biso Dimitrov
Date:
Subject: A question