[HACKERS] Reference by in \d out

2008-02-25 Thread kenneth d'souza
Hi, Refering to this request http://momjian.us/mhonarc/patches_hold/msg00022.html I have created a patch. The output doesn't exaclty match with what is stated here http://momjian.us/mhonarc/patches_hold/msg00023.html. However, it does tell the required details in a similar format. I had

[HACKERS] concurrency in psql

2008-01-01 Thread kenneth d'souza
Hi, I am trying to understand concurrency and mvcc with a small example in psql.Isolation_level is read commited. There are 4 psql session by the same Role. I am executing the commands in the below sequence. Session 1:insert into kentab values ( 1,'A');commit; begin;update kentab set name='

[HACKERS] Lock and Waiters

2007-08-01 Thread kenneth d'souza
I have question on Locks and waiting. In the readme pgsql/src/backend/storage/lmgr/README Each waiter is awoken if (a) its requestdoes not conflict with already-granted locks, and (b) its request doesnot conflict with the requests of prior un-wakable waiters.   Let us imagine if there is Process