Re: [GENERAL] What is the difference between cmin and cmax

2013-07-02 Thread Luca Ferrari
On Tue, Jul 2, 2013 at 5:19 AM, 高健 luckyjack...@gmail.com wrote: Hello: I looked into the source code, and I think I now understand it: cmin and cmax are same! The documentation is too old now. Yes, you figured it out. For short: cmin and cmax are overlapped fields and are used within the same

[GENERAL] What is the difference between cmin and cmax

2013-07-01 Thread 高健
Hello: I have question for cmin and cmax. It is said: cminis: The command identifier (starting at zero) within the inserting transaction. cmax is: The command identifier within the deleting transaction, or zero. http://www.postgresql.org/docs/9.1/static/ddl-system-columns.html

Re: [GENERAL] What is the difference between cmin and cmax

2013-07-01 Thread 高健
Hello: I looked into the source code, and I think I now understand it: cmin and cmax are same! The documentation is too old now. I made another test: In terminal A: pgsql=# begin; BEGIN pgsql=# select * from tab01; id | cd + (0 rows) pgsql=# select xmin,xmax,cmin,cmax,* from tab01;