I was just using
select * from table1;
select * from table2;
select * from tablen;
instead of
begin;
select * from table1;
select * from table2;
select * from tablen;
commit;
Using MS-SQLSERVER the begin trans is "implicit" at first update or delete command. It is not necessary to "worry" about selects before the first update or delete command. I got confused but I understand now. I guess :-)
Thank you,
Clayton
2009/12/19 Jaime Casanova <jcasanov@xxxxxxxxxxxxxxxxxxx>
On Sat, Dec 19, 2009 at 10:58 AM, Clayton Graf <clayton.graf@xxxxxxxxx> wrote:until the lock is released, are your selects all that long?
> 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.
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
don't understand this
> We use two-tier mode,
no
> so is it necessary to shutdown all users before
> perform an ALTER TABLE?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Clayton Graf
