varchar alias not supported as datatype

[Rade Martinović]

Hello pgadmin team.

 

I am using pgAdmin 1.10.0 on Windows XP SP 3.

 

Varchar is a valid alias for character varying in Postgres 8 as stated here: http://www.postgresql.org/docs/8.0/interactive/datatype-character.html 

Still, pgadmin does not accept varchar as valid datatype when creating columns on table. It should not be so.

 

I hope this would be rectified soon.

 

Best regards,

-- 
Rade Martinović, B.Sc.E.E
Software engineer

Belgrade University Computer Center
Kumanovska b.b. 11000 Beograd
Serbia

Tel:            [phone]
Fax:            [phone]
Email:          rade@...
Internet:       http://www.rcub.bg.ac.rs

[Dave Page-7]

2009/10/15 Rade Martinović <rade@...>:
> Hello pgadmin team.
>
> I am using pgAdmin 1.10.0 on Windows XP SP 3.
>
> Varchar is a valid alias for character varying in Postgres 8 as stated here:
> http://www.postgresql.org/docs/8.0/interactive/datatype-character.html
> Still, pgadmin does not accept varchar as valid datatype when creating
> columns on table. It should not be so.

pgAdmin only displays the 'official' names by design.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Rade Martinović]

> 2009/10/15 Rade Martinović <rade@...>:
>> Hello pgadmin team.
>>
>> I am using pgAdmin 1.10.0 on Windows XP SP 3.
>>
>> Varchar is a valid alias for character varying in Postgres 8 as stated
>> here:
>> http://www.postgresql.org/docs/8.0/interactive/datatype-character.html
>> Still, pgadmin does not accept varchar as valid datatype when creating
>> columns on table. It should not be so.
>
> pgAdmin only displays the 'official' names by design.
>

Is not 'serial' alias for integer NOT NULL with a sequence?
I am under impression that varchar is official since it is in the docs.

Not that this is a serious issue, but it's kind of bothering to me.


--
Rade Martinović, B.Sc.E.E
Software engineer

Belgrade University Computer Center
Kumanovska b.b. 11000 Beograd
Serbia

Tel:            [phone]
Fax:            [phone]
Email:          rade@...
Internet:       http://www.rcub.bg.ac.rs 


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

2009/10/15 Rade Martinović <rade@...>:

>> 2009/10/15 Rade Martinović <rade@...>:
>>>
>>> Hello pgadmin team.
>>>
>>> I am using pgAdmin 1.10.0 on Windows XP SP 3.
>>>
>>> Varchar is a valid alias for character varying in Postgres 8 as stated
>>> here:
>>> http://www.postgresql.org/docs/8.0/interactive/datatype-character.html
>>> Still, pgadmin does not accept varchar as valid datatype when creating
>>> columns on table. It should not be so.
>>
>> pgAdmin only displays the 'official' names by design.
>>
> Is not 'serial' alias for integer NOT NULL with a sequence?

Serial is more of a macro than an alias.



--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support