Обсуждение: PostgreSQL locks records (I think)...

Поиск
Список
Период
Сортировка

PostgreSQL locks records (I think)...

От
Joepie Platteau
Дата:
Hi,
I have a very annoying problem :
Postgrsql locks a few records on a few tables.
I cannot open them anymore in my frontend (Access), but if I use 
Pgadmin, then it is possible.
How is this possible?
Does anybody know how to get them unlocked again?  Can I do something 
for not having this in the future?

Thanks!!!
Joepie.



Re: PostgreSQL locks records (I think)...

От
Andreas Pflug
Дата:
Joepie Platteau wrote:

> Hi,
> I have a very annoying problem :
> Postgrsql locks a few records on a few tables.
> I cannot open them anymore in my frontend (Access), but if I use 
> Pgadmin, then it is possible.
> How is this possible?
> Does anybody know how to get them unlocked again?  Can I do something 
> for not having this in the future?
>
> Thanks!!!
> Joepie.
>
Hi Joepie,

this is an Access/ODBC/pgsql problem, so you probably won't get a 
qualified answer here. I'd suggest the pgsql-odbc mailing list.

Regards,
Andreas