From: | "Stas Oskin" <stas(at)neo(dot)co(dot)il> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres locks table schema? |
Date: | 2005-09-22 10:01:40 |
Message-ID: | 200509220858.CLR19460@romy.inter.net.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi.
I will give it a try. Although, I do remember that the lock occurs on the
first transaction - so basically there should be nothing to commit yet?
Thanks,
Stas.
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, September 21, 2005 9:35 PM
To: Stas Oskin
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Postgres locks table schema?
"Stas Oskin" <stas(at)neo(dot)co(dot)il> writes:
> When running SQL scripts, which change the tables' schema, we sometimes
> experience a lock of these tables' schema. The lock occurs on the first
> command of the script, on the first modified table. When this occurs, no
> further schema modification for this table is possible, until the server
is
> restarted, which is very problematic for a production environment.
Try committing the transaction that performed the schema modification
;-)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2005-09-22 10:20:58 | Re: date_trunc('week', '2005-01-01'::TIMESTAMP) |
Previous Message | pgsql-general@list.coretech.ro | 2005-09-22 09:40:00 | date_trunc('week', '2005-01-01'::TIMESTAMP) |