| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dave Harkness <daveh(at)MEconomy(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: LOCK TABLE oddness in PLpgSQL function called via JDBC |
| Date: | 2001-10-02 21:22:52 |
| Message-ID: | 19396.1002057772@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
Dave Harkness <daveh(at)MEconomy(dot)com> writes:
> The problem I'm seeing is that two database transactions,
> initiated via JDBC, are able to obtain simultaneous exclusive table locks
> on the same table.
Sounds to me like JDBC is feeding all your commands through a single
database connection, which means that what you think are independent
transactions are really not. Better take a closer look at what you're
doing.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Harkness | 2001-10-02 21:38:30 | Re: LOCK TABLE oddness in PLpgSQL function called via |
| Previous Message | Dave Harkness | 2001-10-02 21:09:27 | Re: LOCK TABLE oddness in PLpgSQL function called via JDBC |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Harkness | 2001-10-02 21:38:30 | Re: LOCK TABLE oddness in PLpgSQL function called via |
| Previous Message | Vince Vielhaber | 2001-10-02 21:18:27 | Re: [HACKERS] CVS changes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Siebert | 2001-10-02 21:37:20 | Re: TIMESTAMP |
| Previous Message | Tom Lane | 2001-10-02 21:19:21 | Re: driver fails to handle strings in query statements properly |