Excerpts from Mike Broers's message of lun jun 21 14:18:01 -0400 2010: > I need to change service_name column to varchar(55), my plan was to backup > the table with pg_dump, then run the below alter statement: > > alter table dim_product alter column service_name type varchar(55); > > But i am worried about the triggers because I believe that the alter table > statement will rewrite the table and I dont want those triggers firing. The triggers won't fire. It'll do you no harm to try it out in a toy table, though. -- Álvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
