Can i know how many hands my DB contains ?+more

[kraada]

You can put whatever you want in the password field; it isn't checked by PostgreSQL now that you've followed that tutorial. Nothing will be rejected.

[mager]

It had few errors:
http://img717.imageshack.us/i/psql.jpg/

Also do i need to do this only in "PT3 DB" DB ?

P.S
I just understood your "()" comment about the fact that i shouldn't see anything when i type the password. Sorry for that hehe

[kraada]

Oops, those last four lines should all have said lookup_positions not lookup_position. I've edited the original post - if you re-run those lines they should work now.

You only need to do this in PT3 databases. The PostgreSQL default databases (postgres, template0, template1) won't have these tables and the queries won't work there and that's fine. If you use multiple databases you do need to do it for each database you have and then rebuild the cache on all of them if you want the data aggregation to be changed for all databases.

[mager]

Still not working. it writes:
Eror: column "players" does not exist

[kraada]

Edited the post again, try it now.

[mager]

OK i think its good now. I started rebuilding my cache.
Any chance i can verify if this change took place(like see the file/line it updates or something) ?

[kraada]

You can verify the difference by checking out a player's stats in the HUD and looking at them in the main PT3 window on their Positions tab. You'll need to do a little math but if you have a decent enough sample it shouldn't be too hard to double check things.