Home > Archive > Pgadmin > October 2006 > Re: character varying and specfying datatypes









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: character varying and specfying datatypes
Dave Page

2006-10-25, 8:27 am




On 17/10/06 13:39, "Joe Kramer" <cckramer@gmail.com> wrote:

> Hello,
>
> Since new 1.6 beta there is no option to export database schema with
> "character varying" as "varchar". Wasn't there such option in 1.5?
> It's removed now?
>
> Why it's not possible to use varchar in pgadmn dialogs anymore?
>

PgAdmin 1.6 uses the SQL standard typenames rather than the
PostgreSQL-specific ones. This is in line with the PostgreSQL utilities such
as pg_dump and psql.
>
> Another annoying this is in Create table - >ADd Column dialog you
> cannot just type the desired datatype anymore, you're constricted to
> nearest match pgadmin finds for you.
> For example it's not possible to have "bigserial" datatype right away.
> After you type "big" it inserts bigint and you can't change it. The
> only way is to select it form list every time. (List is huge and not
> alphabetically sorted so you have to hunt for required datatype almost
> for every field)
>

Hmm, seems to be a Mac-ism. The wx team changed the behaviour of the combo
boxes in 2.6.2 (iirc), and we had to rewrite a bunch of code to fix things
up. I wonder if we missed this brokeness on Mac, or whether they changed
things again. Išll look into it.

Thanks, Dave.


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com