Re: alter column resize triggers question

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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support