From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <narkeassocia(at)sancharnet(dot)in>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Error if CREATE DOMAIN used |
Date: | 2003-05-20 09:57:37 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B825A190@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-----Original Message-----
From: narkeassocia(at)sancharnet(dot)in
[mailto:narkeassocia(at)sancharnet(dot)in]
Sent: 19 May 2003 08:06
To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-05-20 10:11:41 | pgAdmin 1.5.60 (BETA) Released |
Previous Message | Roger Gordon | 2003-05-20 09:57:00 | Re: Miigration Wizard ignores not nulls & default values |