transactions.out
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- QUERY: BEGIN;
- QUERY: SELECT *
- INTO TABLE xacttest
- FROM aggtest;
- QUERY: INSERT INTO xacttest (a, b) VALUES (777, 777.777);
- QUERY: END;
- QUERY: SELECT a FROM xacttest WHERE a > 100;
- a
- ---
- 777
- (1 row)
- QUERY: BEGIN;
- QUERY: CREATE TABLE disappear (a int4);
- QUERY: DELETE FROM aggtest;
- QUERY: SELECT * FROM aggtest;
- a|b
- -+-
- (0 rows)
- QUERY: ABORT;
- QUERY: SELECT oid FROM pg_class WHERE relname = 'disappear';
- oid
- ---
- (0 rows)
- QUERY: SELECT * FROM aggtest;
- a| b
- ---+-------
- 56| 7.8
- 100| 99.097
- 0|0.09561
- 42| 324.78
- (4 rows)