Re: Locks information

Поиск
Список
Период
Сортировка
От Fernando
Тема Re: Locks information
Дата
Msg-id 20031111172038.8D2913C08B@smtp.latinmail.com
обсуждение исходный текст
Ответ на Locks information  (Fernando <proyectolsd@wanadoo.es>)
Ответы Re: Locks information  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-general
Ups, i didn't explain well. What i meant is that i need, in the source code of the 7.3.4 version, the name of the file
orfiles involve in the locking, i.e., in which file a transaction is locked, where is "waken up" when the lock is
releasedand those things. 
-------
to: Rajesh Kumar Mallah <mallah@trade-india.com>
cc: pgsql-general@postgresql.org
date: 11/11/2003 12:15:27 PM
subject: Re: [GENERAL] Locks information



>
> you can have a look at

> select * from pg_locks;

>
> this works in postgresql ver 7.3

>
>
> regds

> mallah.

>
> Fernando wrote:

>
> >Hello,

> >I'm quite new with PostgreSQL, so this question might be quite dumb, but is there any structure storing information
aboutthe transactions which are locked in a moment? I mean, is there, for example, an array with the IDs of the
transactionswhich are locked in the same object? If so, what is its name? 

> >Thanks in advance!

> >

> >

> >____________________________________________________________

> >http://webmail.wanadoo.es. Tu correo gratuito, r�pido y en espa�ol

> >

> >

> >---------------------------(end of broadcast)---------------------------

> >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

> >
> >

>
>
>


____________________________________________________________
http://webmail.wanadoo.es. Tu correo gratuito, r�pido y en espa�ol


В списке pgsql-general по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Proposal for a cascaded master-slave replication system
Следующее
От: Andrew Rawnsley
Дата:
Сообщение: Re: Proposal for a cascaded master-slave replication system