Re: [GENERAL] the integer type

2006-04-17 Thread Tony Caduto
Peter Eisentraut wrote: Dave Page wrote: 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. Which allows you to use any custom datatype or domain that you l

Re: [GENERAL] the integer type

2006-04-17 Thread Dave Page
> -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: 17 April 2006 20:16 > To: pgsql-general@postgresql.org > Cc: Dave Page; Tony Caduto; chris smith; Zahir Lalani > Subject: Re: [GENERAL] the integer type > > Dave Page wrote: > &g

Re: [GENERAL] the integer type

2006-04-17 Thread Peter Eisentraut
Dave Page wrote: > > 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. > > Which allows you to use any custom datatype or domain that you like. That is complete

Re: [GENERAL] the integer type

2006-04-13 Thread Zahir Lalani
Tony Just a thought. I have spent the last couple of weeks googling for admin tools for Postgres - and never came across yours! Zahir > > > > > PG Lightning Admin was created with input from several MS SQL server > DBAs who just absolutely detested pgAdmin III. > We where converting a large

Re: [GENERAL] the integer type

2006-04-13 Thread Tony Caduto
Zahir Lalani wrote: This is exactly how I felt - It made me wonder whether I should go back to MS SQL - the whole UI experience is much better. But now that I have seen lightning - hopefully it will get easier. Also, I was trying to connect this to ColdFusion/Dreamweaver. Since the field was def

Re: [GENERAL] the integer type

2006-04-13 Thread Zahir Lalani
This is exactly how I felt - It made me wonder whether I should go back to MS SQL - the whole UI experience is much better. But now that I have seen lightning - hopefully it will get easier. Also, I was trying to connect this to ColdFusion/Dreamweaver. Since the field was defined as int4, Coldfusi

Re: [GENERAL] the integer type

2006-04-13 Thread Tony Caduto
Dave Page wrote: Which allows you to use any custom datatype or domain that you like. double precision == float8 (http://www.postgresql.org/docs/8.1/interactive/datatype.html) which works just fine. Regards, Dave. Actually if you try and type in integer in the combobox, it accepts the

Re: [GENERAL] the integer type

2006-04-13 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto > Sent: 13 April 2006 16:19 > To: chris smith > Cc: Zahir Lalani; pgsql-general@postgresql.org > Subject: Re: [GENERAL] the integer type > > It's not

Re: [GENERAL] the integer type

2006-04-13 Thread Tony Caduto
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 wo

Re: [GENERAL] the integer type

2006-04-13 Thread chris smith
e 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 integ

Re: [GENERAL] the integer type

2006-04-13 Thread chris smith
> 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 >

[GENERAL] the integer type

2006-04-13 Thread Zahir Lalani
Hello All 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