Thread: varchar alias not supported as datatype
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: +381-11-3031258 Fax: +381-11-3031259 Email: rade@rcub.bg.ac.rs Internet: http://www.rcub.bg.ac.rs
2009/10/15 Rade Martinović <rade@rcub.bg.ac.rs>: > 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
2009/10/15 Rade Martinović <rade@rcub.bg.ac.rs>: >> 2009/10/15 Rade Martinović <rade@rcub.bg.ac.rs>: >>> >>> 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
> 2009/10/15 Rade Martinović <rade@rcub.bg.ac.rs>: >> 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: +381-11-3031258 Fax: +381-11-3031259 Email: rade@rcub.bg.ac.rs Internet: http://www.rcub.bg.ac.rs