Skip site navigation (1) Skip section navigation (2)

int4 to varchar length (pgadmin3) issue

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: int4 to varchar length (pgadmin3) issue
Date: 2006-08-31 17:21:21
Message-ID: 20060831172121.71205.qmail@web33305.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
hi all,

i initially set up my document revision column as int4
and used integers to define my revisions.  somebody
didn't like integer revisions and requested that i go
to alpha revisions.

when i change (in pgadmin3) the int4 columns to
varchar, everything goes well in pgadmin3 up until the
grayed out box for the length of the varchar stays
grayed out.

iow, i want to limit the the newly converted varchar
revision to 2 characters, but can't due to the grayed
out boxes in pgadmin3.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-08-31 17:36:56
Subject: Re: int4 to varchar length (pgadmin3) issue
Previous:From: A. KretschmerDate: 2006-08-31 14:10:40
Subject: Re: moving content of a table to another table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group