Postgres Pro
Downloads
Home   >   mailing lists

Problem with using domains - Mailing list pgadmin-support

From Martin Susil
Subject Problem with using domains
Date
Msg-id 004e01c4ccec$66680de0$3702a8c0@SUSILMNTB
Whole thread Raw
Responses Re: Problem with using domains
List pgadmin-support
Tree view
Hello,

It seems I found a small bug:

I use domains as data type aliases in my db:

CREATE DOMAIN my_schema.t_varchar AS varchar;

Now lets say I want to edit (or insert) some values in my_schema.my_table so
I run pgAdmin and 'right-click & View Data' the table.
Domains under names of the columns are displayed correctly (without schema
prefix though) but when I try to insert data into a new row I get the
following error:

ERROR: type t_varchar does not exist

I m using pgAdmin III 1.2.0 RC2 (Windows XP) with PostgreSQL 8.0 Beta 2
(also on WinXP)


Regards
Martin Susil

pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pgadmin crashes on SuSE 9.2/wxGTK 2.5.3
Next
From: Andreas Pflug
Date:
Subject: Re: Problem with using domains