Re: Error if CREATE DOMAIN used

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.

Browse pgadmin-support by date

  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