chris smith wrote:

What error do you get? I'm sure pgAdmin will show something.

Try it from console:

psql.exe dbname
create table t1(a int);

(Always CC the list, someone else might be able to help you if I don't
know the answer).
It's not a error, pgAdmin III simply does not display the word integer in it's drop down comboboxes, it uses all the internal representation of types not the SQL standard aliases.

PG Lightning Admin on the other hand does use the SQL standard names in the comboboxes which make things a little easier for those coming from other databases and that's why PG Lightning Admin is the best choice for all users running a win32 desktop or coming from another database system such as MS SQL server. Just because it's free (pgAdminIII) does not mean it should be your only or best choice.

pgAdmin III also won't accept double precision in it's type selection combobox.

Later,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to