On 4/14/06, Zahir Lalani <[EMAIL PROTECTED]> wrote: > Hi Chris > > I am using pgAdmin III. > > Created a table, then started adding fields. This is where the problem > hits - the drop down does not give you an INTEGER option, so you cannot > shoose it. > Also I tried creating a script in the query view and running it, but > again, if I used INT or INTEGER it errors. Change it INT4 and its fine.
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). > > -----Original Message----- > > From: chris smith [mailto:[EMAIL PROTECTED] > > Sent: 13 April 2006 15:17 > > To: Zahir Lalani > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] the integer type > > > > > > > I have only recently started to use Postgresql and have a > > problem. I am > > > using v8.1 on windows. > > > I cannot seem to get the DB to accept either INT or INTEGER > > as a type > > > when using the admin tool. Only INT2 or INT4 work. > > > I even downloaded Navicat trial and this has the same > > issue. Is there a > > > setup required to allow these > > > standard types to be enabled? > > > > It's a built in type so you don't need to do anything. > > > > So something like this: > > > > create table t1(a int); > > > > fails? > > > > What message do you get? > > > > -- > > Postgresql & php tutorials > > http://www.designmagick.com/ > > > > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > -- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster