| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem with lock? |
| Date: | 2003-09-30 11:11:57 |
| Message-ID: | Pine.LNX.4.44.0309301311080.6281-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bjørn T Johansen writes:
> I run the following SQL before updating one table:
>
> "lock table tablename"
>
> but when I try do update the same table later on, the lock table command
> just hangs (i.e the table is already locked).
> It was my understanding that this lock was removed when I call commit or
> do I have to explicitly unlock the table somehow?
Show us what commands you are running, in what sequence, how many
sessions, etc.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John K. Herreshoff | 2003-09-30 11:21:35 | Re: FUD!! ODBC will not be supported by Microsoft in the future |
| Previous Message | Mike Mascari | 2003-09-30 11:06:49 | Functional index performance question |