Search Postgresql Archives

Re: the integer type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 4/14/06, Zahir Lalani <zahir@xxxxxxxxxxx> 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:dmagick@xxxxxxxxx]
> > Sent: 13 April 2006 15:17
> > To: Zahir Lalani
> > Cc: pgsql-general@xxxxxxxxxxxxxx
> > 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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux