春风化雨

1、事务sql语句BEGIN;update b_app set total_duration=total_duration+1 where id = 273;-- END;2、锁表语句查询查询锁表pid与锁表语句select pid, state, usename, query, query_start from pg_stat_activity where pid in ( select pid from pg_locks l join pg_class t on l.rela.

show transaction_isolation;

1、主键id bigserial PRIMARY KEY,2、示例DROP TABLE IF EXISTS "public"."e_role_data_section";CREATE TABLE "public"."e_role_data_section" ( id bigserial PRIMARY KEY, "role_id" int8, "section_id" int8);