Thread: Column lenght

Column lenght

From
Jean-Michel POURE
Date:
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.

Cheers,
Jean-Michel

Re: Column lenght

From
Dave Page
Date:

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 02 October 2001 16:34
> To: pgadmin-hackers@postgresql.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.

Re: Column lenght

From
Jean-Michel POURE
Date:
>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.

Hello my friend,

The only thing we can trust is plain 'source code' not PostgreSQL derived
or user logging code.

Later/JMP