| From: | "Graham Vickrage" <graham(at)digitalplanit(dot)com> |
|---|---|
| To: | "Postgres SQL" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Strategy for unlocking query |
| Date: | 2001-04-04 15:34:54 |
| Message-ID: | NDBBJABDILOPAOOMFJHOGEAJCJAA.graham@digitalplanit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have just done a rather large transaction via a telnet/psql session which
executed OK. The problem occured when the telnet session timed out before I
could commit the rows.
This must have locked the rows in question because when I tried to vacuum
the table it just hung.
What is the best way of dealing with this problem as I ended up stopping and
restarting the postmaster?
Also are functions within functions dealt with in a 'transactional' sense?
Cheers
Graham
| Attachment | Content-Type | Size |
|---|---|---|
| winmail.dat | application/ms-tnef | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-04-04 15:54:22 | Re: Query broken under 7.1RC2 |
| Previous Message | Kyle | 2001-04-04 15:24:41 | Query broken under 7.1RC2 |