I wanted to see which tables/transaction have acquired or are waiting for which locks....
as far as i know there are two ways to do it....
1) pg_locks ::: but we need to continously keep getting data from the table and it also locks lock manager data structures which is not a good thing to do...
2) trace_locks,trace_lwlocks ... etc etc.... ::: well for this my server says undefined parameters... so as far as i know i need to rebuild the server with some flag...
is there any other better way by which i can get a list of locks acquired and waited for during entire run of my application....
thx
Himanshu
Do you Yahoo!?
Yahoo! Small Business -
Try our new resources site!