云数据库 GaussDB-ABORT:示例

时间：2023-11-01 16:22:24

云数据库 GaussDB

示例

  
       --创建表customer_demographics_t1。postgres=# CREATE TABLE customer_demographics_t1(    CD_DEMO_SK                INTEGER               NOT NULL,    CD_GENDER                 CHAR(1)                       ,    CD_MARITAL_STATUS         CHAR(1)                       ,    CD_EDUCATION_STATUS       CHAR(20)                      ,    CD_PURCHASE_ESTIMATE      INTEGER                       ,    CD_CREDIT_RATING          CHAR(10)                      ,    CD_DEP_COUNT              INTEGER                       ,    CD_DEP_EMPLOYED_COUNT     INTEGER                       ,    CD_DEP_COLLEGE_COUNT      INTEGER)WITH (ORIENTATION = COLUMN,COMPRESSION=MIDDLE)DISTRIBUTE BY HASH (CD_DEMO_SK);--插入记录。postgres=# INSERT INTO customer_demographics_t1 VALUES(1920801,'M', 'U', 'DOCTOR DEGREE', 200, 'GOOD', 1, 0,0);--开启事务。postgres=# START TRANSACTION;--更新字段值。postgres=# UPDATE customer_demographics_t1 SET cd_education_status= 'Unknown';--终止事务，上面所执行的更新会被撤销掉。postgres=# ABORT; --查询数据。postgres=# SELECT * FROM customer_demographics_t1 WHERE cd_demo_sk = 1920801;cd_demo_sk | cd_gender | cd_marital_status | cd_education_status  | cd_purchase_estimate | cd_credit_rating | cd_dep_count | cd_dep_employed_count | cd_dep_college_count ------------+-----------+-------------------+----------------------+----------------------+------------------+--------------+-----------------------+----------------------    1920801 | M         | U                 | DOCTOR DEGREE        |                  200 | GOOD             |            1 |                     0 |                    0(1 row)--删除表。postgres=# DROP TABLE customer_demographics_t1;