| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Patrick Dunford <dunfordsoft(at)clear(dot)net(dot)nz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Server does not reply to Alter Table |
| Date: | 2002-02-05 15:58:24 |
| Message-ID: | 25074.1012924704@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Patrick Dunford <dunfordsoft(at)clear(dot)net(dot)nz> writes:
> Using pgsql 7.1.3 I have found that on occasions, there is no reply to an
> SQL statement like
> ALTER TABLE x
> ADD COLUMN y z
You sure it's not just waiting for some other transaction to give up a
lock on the table? ALTER TABLE ADD COLUMN should be essentially
instantaneous, since it doesn't touch the table data. But it needs to
get exclusive lock on the table first.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2002-02-05 16:01:24 | PostgreSQL v7.2 Final Release |
| Previous Message | Tom Lane | 2002-02-05 15:50:08 | Re: rule on update |