Re: Problem with using domains

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Martin Susil <spam(at)susil(dot)net>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Problem with using domains
Date: 2004-11-18 11:48:53
Message-ID: 419C8C25.3050902@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Martin Susil wrote:
> 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

Schema is missing. Fixed in CVS, thanks for reporting.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-11-18 18:05:35 Re: Can' change comments on column
Previous Message Martin Susil 2004-11-17 21:28:36 Problem with using domains