【PostgreSQL】PostgreSQL给表加主键-可重复执行
【PostgreSQL】PostgreSQL给表加主键-可重复执行
alter table tzq.tzq_log_t add column IF NOT EXISTS log_id int8;
COMMENT ON COLUMN tzq.tzq_log_t.log_id IS '日志表id:IT主键';
CREATE SEQUENCE IF NOT EXISTS seq_tzq_log_t;
ALTER TABLE tzq.tzq_log_t ALTER COLUMN log_id SET DEFAULT nextval('seq_tzq_log_t');
set app.current_tenant = '11111111111111111111111111111111';
update tzq.tzq_log_t set log_id = nextval('seq_tzq_log_t') where log_id is null;
alter table tzq.tzq_log_t alter column log_id set not null;
ALTER TABLE tzq.tzq_log_t DROP constraint if exists tzq_log_t_pkey;
ALTER TABLE tzq.tzq_log_t add CONSTRAINT tzq_log_t_pkey PRIMARY KEY (log_id);