On Wed, Dec 26, 2007 at 05:48:14PM -0800, ivan.hou wrote: > > XID is transcation ID?
Yes.
> so, "select * from mydb" is a transcation?
Yes.
> if i executed "select * from mydb" twice, the XID wil be increased by 2
Yep. Whereas if you did
BEGIN;
SELECT 1;
SELECT 1;
COMMIT;
the xid would be increased by 1.
A
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
