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. Also, from a quick scan of the code it appears that it won't
OK, I see that a conversion that needs a USING clause is hard to handle
with the GUI. But changing the size of a char doesn't need USING:
CREATE TABLE t1 ( c1 char(20) );
ALTER TABLE t1 ALTER column c1 TYPE char(30);
ALTER TABLE t1 ALTER column c1 TYPE char(10);
Its also possible (e.g.) to change from CHAR() to INT, (but not vice
versa) etc. without the USING clause. It would be great if I can do such
clear conversions with pgadminIII.
let you try to change the types of columns referenced in foreign keys.
yes, of course, but perhaps you can implement a 'alter type cascade'
option. (OK, priority -999 :) )
Walter
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
