On Sat, Dec 19, 2009 at 10:58 AM, Clayton Graf <clayton.graf@xxxxxxxxx> wrote: > Ok, but this is really my problem: I cannot perform an ALTER TABLE with the > system in production mode, because the ALTER TABLE hangs due an > AccessShareLock. until the lock is released, are your selects all that long? besides, why are you ALTERing the table in production... i guess clients will suffer if the expect less or more columns than the ones they receive from the ALTERed table > We use two-tier mode, don't understand this > so is it necessary to shutdown all users before > perform an ALTER TABLE? no -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
