Re: Column lenght

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Column lenght
Date: 2001-10-02 16:23:46
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00B5B@dogbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 02 October 2001 16:34
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Column lenght
>
>
> Hello,
>
> Try the following query:
> create table essai(
> ID char(12) not null,
> primary key (id)
> );
>
> The definition pane displays no lenght:
> CREATE TABLE "essai" (
> "id" bpchar NOT NULL,
> CONSTRAINT "essai_pkey" PRIMARY KEY ("id")
> );
>
> The property editor show the correct column lenght.

This should be fixed now. Char columns get converted to bpchar in
PostgreSQL, but you can't specify a length for bpchar!

All columns will now display correctly as char(n).

Regards, Dave.

Browse pgadmin-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-10-02 16:27:19 Re: What about CREATE OR REPLACE FUNCTION?
Previous Message Dave Page 2001-10-02 16:09:21 Re: Table modification