Re: ecpg PREPARE is not thread safe - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Re: ecpg PREPARE is not thread safe
Date
Msg-id 20070921201822.68ED.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: ecpg PREPARE is not thread safe  (Michael Meskes <meskes@postgresql.org>)
List pgsql-hackers
Michael Meskes <meskes@postgresql.org> wrote:

> Right now the prepared statements are not considered connection
> specific. I'm not sure whether the standard says anything about this.
> But moving this data shoudln't be a major problem.
> 
> > Even if we have some kinds of exclusive controls, current ecpg might not
> > good at prepared statements when we use multiple connections in a signle
> > thread or do multiple PREPARE in multiple threads. If so, 1 and 2 are not
> > correct fixes.
> 
> Sorry, I don't get this. What exactly are you talking about here?

I'm worried that prepared statements are used in another connection.
ECPG does not consider in which connection the statements is prepared.
Are there any mix-up problem here? If no, the TSD approach is enough
to fix the race condition. If yes, per-connection approach is needed.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: compiler warnings in ecpglib/execute.c (uninitialized local variable 'prepname' used)
Next
From: Abhijit Menon-Sen
Date:
Subject: TODO/exotic features/sql*net