Re: [pgadmin-support] Alter columntype with pgadmin?

2005-05-27 Thread Walter Haslbeck
Hi, If there is a suitable cast in the database, then the combo box will be populated with usable column types and made selectable (try it with varchar which should be castable). Any other conversion requires the use of the USING clause to the alter table statement which pgAdmin doesn't support.

Re: [pgadmin-support] Alter columntype with pgadmin?

2005-05-27 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Walter Haslbeck > Sent: 27 May 2005 10:48 > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Alter columntype with pgadmin? > > Hi, > > > pgAdmin does support this feature in

Re: [pgadmin-support] Alter columntype with pgadmin?

2005-05-27 Thread Walter Haslbeck
Hi, pgAdmin does support this feature in the 1.3 development series, but I'm pretty sure it was in 1.2 as well. Well, I'm using the latest binary snapshot of the win32-version (20050526) and can't find this feature. If I open the propertys for a column of e.g. type 'char', the datatype and s

Re: [pgadmin-support] Alter columntype with pgadmin?

2005-05-27 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Walter Haslbeck > Sent: 27 May 2005 09:12 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Alter columntype with pgadmin? > > Hi, > > now that PostgreSQL 8 supports changing the

Re: [pgadmin-support] Alter columntype with pgadmin?

2005-05-27 Thread Vincent CARON
on 27/05/2005 10:11 Walter Haslbeck said the following: > Hi, > > now that PostgreSQL 8 supports changing the datatype of a column with > the 'ALTER TABLE ... ALTER COLUMN ... TYPE new_type [USING ...]' syntax > it would be great if pgadminIII has an option to do this via GUI. > > Are there any e

[pgadmin-support] Alter columntype with pgadmin?

2005-05-27 Thread Walter Haslbeck
Hi, now that PostgreSQL 8 supports changing the datatype of a column with the 'ALTER TABLE ... ALTER COLUMN ... TYPE new_type [USING ...]' syntax it would be great if pgadminIII has an option to do this via GUI. Are there any efforts to support this feature in pgadminIII? Walter ---