MargaretGillon@xxxxxxxxxxxxxx wrote: > Using PGADMINIII I added a column of this type to my database but when I > try to update it I get an error. > > column: > ALTER TABLE datatype ADD COLUMN charflag "char"[]; You added an array of "char", which is not the same. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support