这里有一些真正的硬核答案,我'm assuming it used to be really bad at around the time when this has been asked, since a lot of answers from here don'适用于9.3版本 . 自8.0版以来documentation提供了这个问题的答案:
SELECT setval('serial', max(id)) FROM distributors;
此外,如果您需要处理区分大小写的序列名称,那么您就是这样做的:
SELECT setval('"Serial"', max(id)) FROM distributors;
174
这将重置所有公共序列,不对表名或列名进行假设 . 在8.4版本上测试过
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text, columnname text, sequence_name text) RETURNS "pg_catalog"."void" AS
$body$
DECLARE
BEGIN
EXECUTE 'SELECT setval( ''' || sequence_name || ''', ' || '(SELECT MAX(' || columnname || ') FROM ' || tablename || ')' || '+1)';
END;
$body$ LANGUAGE 'plpgsql';
select table_name || '_' || column_name || '_seq', reset_sequence(table_name, column_name, table_name || '_' || column_name || '_seq') from information_schema.columns where column_default like 'nextval%';
CREATE OR REPLACE FUNCTION sequence_max_value(oid) RETURNS bigint
VOLATILE STRICT LANGUAGE plpgsql AS $$
DECLARE
tabrelid oid;
colname name;
r record;
newmax bigint;
BEGIN
FOR tabrelid, colname IN SELECT attrelid, attname
FROM pg_attribute
WHERE (attrelid, attnum) IN (
SELECT adrelid::regclass,adnum
FROM pg_attrdef
WHERE oid IN (SELECT objid
FROM pg_depend
WHERE refobjid = $1
AND classid = 'pg_attrdef'::regclass
)
) LOOP
FOR r IN EXECUTE 'SELECT max(' || quote_ident(colname) || ') FROM ' || tabrelid::regclass LOOP
IF newmax IS NULL OR r.max > newmax THEN
newmax := r.max;
END IF;
END LOOP;
END LOOP;
RETURN newmax;
END; $$ ;
select relname, setval(oid, sequence_max_value(oid))
from pg_class
where relkind = 'S';
使用不同的qual可以仅重置某个模式中的序列,依此类推 . 例如,如果要调整“公共”模式中的序列:
select relname, setval(pg_class.oid, sequence_max_value(pg_class.oid))
from pg_class, pg_namespace
where pg_class.relnamespace = pg_namespace.oid and
nspname = 'public' and
relkind = 'S';
SELECT pg_catalog.setval(pg_get_serial_sequence('table_name', 'id'), (SELECT MAX(id) FROM table_name)+1);
或者更简洁:
SELECT pg_catalog.setval(pg_get_serial_sequence('table_name', 'id'), MAX(id)) FROM table_name;
但是这个表单无法正确处理空表,因为max(id)为null,并且你也不能设置0,因为它超出了序列的范围 . 一种解决方法是采用 ALTER SEQUENCE 语法,即
ALTER SEQUENCE table_name_id_seq RESTART WITH 1;
ALTER SEQUENCE table_name_id_seq RESTART; -- 8.4 or higher
但 ALTER SEQUENCE 的用途有限,因为序列名称和重启值不能是表达式 .
似乎最好的通用解决方案是使用false作为第3个参数调用 setval ,允许我们指定"next value to use":
SELECT setval(pg_get_serial_sequence('t1', 'id'), coalesce(max(id),0) + 1, false) FROM t1;
这勾选了我的所有方框:
避免硬编码实际的序列名称
正确处理空表
处理具有现有数据的表,并且不会在序列中留下空洞
最后请注意, pg_get_serial_sequence 仅在序列归列所有时才有效 . 如果将递增列定义为 serial 类型,则会出现这种情况,但是如果手动添加序列,则必须确保也执行 ALTER SEQUENCE .. OWNED BY .
即如果 serial 类型用于表创建,这应该都可以工作:
CREATE TABLE t1 (
id serial,
name varchar(20)
);
SELECT pg_get_serial_sequence('t1', 'id'); -- returns 't1_id_seq'
-- reset the sequence, regardless whether table has rows or not:
SELECT setval(pg_get_serial_sequence('t1', 'id'), coalesce(max(id),0) + 1, false) FROM t1;
但是如果手动添加序列:
CREATE TABLE t2 (
id integer NOT NULL,
name varchar(20)
);
CREATE SEQUENCE t2_custom_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE t2 ALTER COLUMN id SET DEFAULT nextval('t2_custom_id_seq'::regclass);
ALTER SEQUENCE t2_custom_id_seq OWNED BY t2.id; -- required for pg_get_serial_sequence
SELECT pg_get_serial_sequence('t2', 'id'); -- returns 't2_custom_id_seq'
-- reset the sequence, regardless whether table has rows or not:
SELECT setval(pg_get_serial_sequence('t2', 'id'), coalesce(max(id),0) + 1, false) FROM t1;
4
这个答案是毛罗的副本 .
drop function IF EXISTS rebuilt_sequences() RESTRICT;
CREATE OR REPLACE FUNCTION rebuilt_sequences() RETURNS integer as
$body$
DECLARE sequencedefs RECORD; c integer ;
BEGIN
FOR sequencedefs IN Select
DISTINCT(constraint_column_usage.table_name) as tablename,
constraint_column_usage.column_name as columnname,
replace(replace(columns.column_default,'''::regclass)',''),'nextval(''','') as sequencename
from information_schema.constraint_column_usage, information_schema.columns
where constraint_column_usage.table_schema ='public' AND
columns.table_schema = 'public' AND columns.table_name=constraint_column_usage.table_name
AND constraint_column_usage.column_name = columns.column_name
AND columns.column_default is not null
ORDER BY sequencename
LOOP
EXECUTE 'select max('||sequencedefs.columnname||') from ' || sequencedefs.tablename INTO c;
IF c is null THEN c = 0; END IF;
IF c is not null THEN c = c+ 1; END IF;
EXECUTE 'alter sequence ' || sequencedefs.sequencename ||' minvalue '||c ||' start ' || c ||' restart with ' || c;
END LOOP;
RETURN 1; END;
$body$ LANGUAGE plpgsql;
select rebuilt_sequences();
0
-- Login to psql and run the following
-- What is the result?
SELECT MAX(id) FROM your_table;
-- Then run...
-- This should be higher than the last result.
SELECT nextval('your_table_id_seq');
-- If it's not higher... run this set the sequence last to your highest id.
-- (wise to run a quick pg_dump first...)
BEGIN;
-- protect against concurrent inserts while you update the counter
LOCK TABLE your_table IN EXCLUSIVE MODE;
-- Update the sequence
SELECT setval('your_table_id_seq', COALESCE((SELECT MAX(id)+1 FROM your_table), 1), false);
COMMIT;
BEGIN;
LOCK TABLE tbl IN EXCLUSIVE MODE;
SELECT setval('tbl_tbl_id_seq', max(tbl_id))
FROM tbl
HAVING max(tbl_id) > (SELECT last_value FROM tbl_tbl_id_seq);
COMMIT;
0
我的版本使用第一个,有一些错误检查...
BEGIN;
CREATE OR REPLACE FUNCTION reset_sequence(_table_schema text, _tablename text, _columnname text, _sequence_name text)
RETURNS pg_catalog.void AS
$BODY$
DECLARE
BEGIN
PERFORM 1
FROM information_schema.sequences
WHERE
sequence_schema = _table_schema AND
sequence_name = _sequence_name;
IF FOUND THEN
EXECUTE 'SELECT setval( ''' || _table_schema || '.' || _sequence_name || ''', ' || '(SELECT MAX(' || _columnname || ') FROM ' || _table_schema || '.' || _tablename || ')' || '+1)';
ELSE
RAISE WARNING 'SEQUENCE NOT UPDATED ON %.%', _tablename, _columnname;
END IF;
END;
$BODY$
LANGUAGE 'plpgsql';
SELECT reset_sequence(table_schema, table_name, column_name, table_name || '_' || column_name || '_seq')
FROM information_schema.columns
WHERE column_default LIKE 'nextval%';
DROP FUNCTION reset_sequence(_table_schema text, _tablename text, _columnname text, _sequence_name text) ;
COMMIT;
drop function IF EXISTS rebuilt_sequences() RESTRICT;
CREATE OR REPLACE FUNCTION rebuilt_sequences() RETURNS integer as
$body$
DECLARE sequencedefs RECORD; c integer ;
BEGIN
FOR sequencedefs IN Select
constraint_column_usage.table_name as tablename,
constraint_column_usage.table_name as tablename,
constraint_column_usage.column_name as columnname,
replace(replace(columns.column_default,'''::regclass)',''),'nextval(''','') as sequencename
from information_schema.constraint_column_usage, information_schema.columns
where constraint_column_usage.table_schema ='public' AND
columns.table_schema = 'public' AND columns.table_name=constraint_column_usage.table_name
AND constraint_column_usage.column_name = columns.column_name
AND columns.column_default is not null
LOOP
EXECUTE 'select max('||sequencedefs.columnname||') from ' || sequencedefs.tablename INTO c;
IF c is null THEN c = 0; END IF;
IF c is not null THEN c = c+ 1; END IF;
EXECUTE 'alter sequence ' || sequencedefs.sequencename ||' restart with ' || c;
END LOOP;
RETURN 1; END;
$body$ LANGUAGE plpgsql;
select rebuilt_sequences();
user457226解决方案:
--drop function IF EXISTS reset_sequence (text,text) RESTRICT;
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text,columnname text) RETURNS bigint --"pg_catalog"."void"
AS
$body$
DECLARE seqname character varying;
c integer;
BEGIN
select tablename || '_' || columnname || '_seq' into seqname;
EXECUTE 'SELECT max("' || columnname || '") FROM "' || tablename || '"' into c;
if c is null then c = 0; end if;
c = c+1; --because of substitution of setval with "alter sequence"
--EXECUTE 'SELECT setval( "' || seqname || '", ' || cast(c as character varying) || ', false)'; DOES NOT WORK!!!
EXECUTE 'alter sequence ' || seqname ||' restart with ' || cast(c as character varying);
RETURN nextval(seqname)-1;
END;
$body$ LANGUAGE 'plpgsql';
select sequence_name, PG_CLASS.relname, PG_ATTRIBUTE.attname,
reset_sequence(PG_CLASS.relname,PG_ATTRIBUTE.attname)
from PG_CLASS
join PG_ATTRIBUTE on PG_ATTRIBUTE.attrelid = PG_CLASS.oid
join information_schema.sequences
on information_schema.sequences.sequence_name = PG_CLASS.relname || '_' || PG_ATTRIBUTE.attname || '_seq'
where sequence_schema='public';
5
重置所有序列,没有关于名称的假设,除了每个表的主键是“id”:
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text, columnname text)
RETURNS "pg_catalog"."void" AS
$body$
DECLARE
BEGIN
EXECUTE 'SELECT setval( pg_get_serial_sequence(''' || tablename || ''', ''' || columnname || '''),
(SELECT COALESCE(MAX(id)+1,1) FROM ' || tablename || '), false)';
END;
$body$ LANGUAGE 'plpgsql';
select table_name || '_' || column_name || '_seq', reset_sequence(table_name, column_name) from information_schema.columns where column_default like 'nextval%';
17
如果在加载自定义SQL数据进行初始化时看到此错误,则另一种避免这种情况的方法是:
而不是写:
INSERT INTO book (id, name, price) VALUES (1 , 'Alchemist' , 10),
从初始数据中删除 id (主键)
INSERT INTO book (name, price) VALUES ('Alchemist' , 10),
这使Postgres序列保持同步!
5
从公共重置所有序列
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text) RETURNS "pg_catalog"."void" AS
$body$
DECLARE
BEGIN
EXECUTE 'SELECT setval( '''
|| tablename
|| '_id_seq'', '
|| '(SELECT id + 1 FROM "'
|| tablename
|| '" ORDER BY id DESC LIMIT 1), false)';
END;
$body$ LANGUAGE 'plpgsql';
select sequence_name, reset_sequence(split_part(sequence_name, '_id_seq',1)) from information_schema.sequences
where sequence_schema='public';
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text, columnname text)
RETURNS "pg_catalog"."void" AS
$body$
DECLARE
BEGIN
EXECUTE format('SELECT setval(pg_get_serial_sequence(''%1$I'', %2$L),
(SELECT COALESCE(MAX(%2$I)+1,1) FROM %1$I), false)',tablename,columnname);
END;
$body$ LANGUAGE 'plpgsql';
SELECT format('%s_%s_seq',table_name,column_name), reset_sequence(table_name,column_name)
FROM information_schema.columns WHERE column_default like 'nextval%';
"TableName" --it thinks it's a table or column
'TableName' --it thinks it's a string, but makes it lower case
'"TableName"' --it works!
这是使用格式字符串中的 ''%1$I'' 实现的, '' 使得撇号 1$ 表示第一个arg, I 表示引号
48
把它们放在一起
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text)
RETURNS "pg_catalog"."void" AS
$body$
DECLARE
BEGIN
EXECUTE 'SELECT setval( pg_get_serial_sequence(''' || tablename || ''', ''id''),
(SELECT COALESCE(MAX(id)+1,1) FROM ' || tablename || '), false)';
END;
$body$ LANGUAGE 'plpgsql';
将修复给定表的' id' 序列(例如,通常需要django) .
2
SELECT setval... 使JDBC变成了bork,所以这里有一种与Java兼容的方法:
-- work around JDBC 'A result was returned when none was expected.'
-- fix broken nextval due to poorly written 20140320100000_CreateAdminUserRoleTables.sql
DO 'BEGIN PERFORM setval(pg_get_serial_sequence(''admin_user_role_groups'', ''id''), 1 + COALESCE(MAX(id), 0), FALSE) FROM admin_user_role_groups; END;';
36
重新检查公共模式函数中的所有序列
CREATE OR REPLACE FUNCTION public.recheck_sequence (
)
RETURNS void AS
$body$
DECLARE
_table_name VARCHAR;
_column_name VARCHAR;
_sequence_name VARCHAR;
BEGIN
FOR _table_name IN SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname = 'public' LOOP
FOR _column_name IN SELECT column_name FROM information_schema.columns WHERE table_name = _table_name LOOP
SELECT pg_get_serial_sequence(_table_name, _column_name) INTO _sequence_name;
IF _sequence_name IS NOT NULL THEN
EXECUTE 'SELECT setval('''||_sequence_name||''', COALESCE((SELECT MAX('||quote_ident(_column_name)||')+1 FROM '||quote_ident(_table_name)||'), 1), FALSE);';
END IF;
END LOOP;
END LOOP;
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;
DO
$do$
DECLARE tablename text;
BEGIN
-- change the where statments to include or exclude whatever tables you need
FOR tablename IN SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE' AND table_name != '__EFMigrationsHistory'
LOOP
EXECUTE format('SELECT setval(pg_get_serial_sequence(''"%s"'', ''Id''), (SELECT MAX("Id") + 1 from "%s"))', tablename, tablename);
END LOOP;
END
$do$
2
要重新启动所有序列为1,请使用:
-- Create Function
CREATE OR REPLACE FUNCTION "sy_restart_seq_to_1" (
relname TEXT
)
RETURNS "pg_catalog"."void" AS
$BODY$
DECLARE
BEGIN
EXECUTE 'ALTER SEQUENCE '||relname||' RESTART WITH 1;';
END;
$BODY$
LANGUAGE 'plpgsql';
-- Use Function
SELECT
relname
,sy_restart_seq_to_1(relname)
FROM pg_class
WHERE relkind = 'S';
select sequence_name, --PG_CLASS.relname, PG_ATTRIBUTE.attname
reset_sequence(split_part(sequence_name, '_id_seq',1))
from PG_CLASS
join PG_ATTRIBUTE on PG_ATTRIBUTE.attrelid = PG_CLASS.oid
join information_schema.sequences
on information_schema.sequences.sequence_name = PG_CLASS.relname || '_' || PG_ATTRIBUTE.attname
where sequence_schema='public';
这是user457226解决方案的扩展,适用于某些感兴趣的列名称不是“ID”的情况 .
47
我建议在postgres wiki上找到这个解决方案 . 它会更新表的所有序列 .
SELECT 'SELECT SETVAL(' ||
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) ||
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' ||
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
FROM pg_class AS S,
pg_depend AS D,
pg_class AS T,
pg_attribute AS C,
pg_tables AS PGT
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
AND T.relname = PGT.tablename
ORDER BY S.relname;
do --check seq not in sync
$$
declare
_r record;
_i bigint;
_m bigint;
begin
for _r in (
SELECT relname,nspname,d.refobjid::regclass, a.attname, refobjid
FROM pg_depend d
JOIN pg_attribute a ON a.attrelid = d.refobjid AND a.attnum = d.refobjsubid
JOIN pg_class r on r.oid = objid
JOIN pg_namespace n on n.oid = relnamespace
WHERE d.refobjsubid > 0 and relkind = 'S'
) loop
execute format('select last_value from %I.%I',_r.nspname,_r.relname) into _i;
execute format('select max(%I) from %s',_r.attname,_r.refobjid) into _m;
if coalesce(_m,0) > _i then
raise info '%',concat('changed: ',_r.nspname,'.',_r.relname,' from:',_i,' to:',_m);
execute format('alter sequence %I.%I restart with %s',_r.nspname,_r.relname,_m+1);
end if;
end loop;
end;
$$
;
25 回答
这里有一些真正的硬核答案,我'm assuming it used to be really bad at around the time when this has been asked, since a lot of answers from here don'适用于9.3版本 . 自8.0版以来documentation提供了这个问题的答案:
此外,如果您需要处理区分大小写的序列名称,那么您就是这样做的:
这将重置所有公共序列,不对表名或列名进行假设 . 在8.4版本上测试过
当序列名称,列名称,表名称或模式名称具有空格,标点符号等有趣字符时,这些函数充满了危险 . 我写了这个:
您可以通过向OID传递它来为单个序列调用它,它将返回任何具有默认序列的表所使用的最大数字;或者您可以使用这样的查询运行它,以重置数据库中的所有序列:
使用不同的qual可以仅重置某个模式中的序列,依此类推 . 例如,如果要调整“公共”模式中的序列:
请注意,由于setval()的工作原理,您无需在结果中添加1 .
作为结束语,我必须警告一些数据库似乎有默认链接到序列的方式不会让系统目录具有它们的完整信息 . 当你在psql的\ d中看到这样的事情时会发生这种情况:
请注意,除了:: regclass强制转换之外,该default子句中的nextval()调用还有一个:: text强制转换 . 我认为这是因为数据库是旧的PostgreSQL版本的pg_dump . 会发生的是上面的函数sequence_max_value()将忽略这样的表 . 要解决此问题,您可以重新定义DEFAULT子句以直接引用序列而不使用强制转换:
然后psql正确显示它:
一旦修复了该函数,该函数就可以正常运行此表以及可能使用相同序列的所有其他函数 .
ALTER SEQUENCE sequence_name RESTART WITH(SELECT max(id)FROM table_name);不起作用 .
复制自@tardate回答:
丑陋的黑客使用一些shell魔法修复它,不是一个很好的解决方案,但可能激发其他类似的问题:)
pg_get_serial_sequence可用于避免对序列名称的任何不正确的假设 . 这会一次性重置序列:
或者更简洁:
但是这个表单无法正确处理空表,因为max(id)为null,并且你也不能设置0,因为它超出了序列的范围 . 一种解决方法是采用
ALTER SEQUENCE
语法,即但
ALTER SEQUENCE
的用途有限,因为序列名称和重启值不能是表达式 .似乎最好的通用解决方案是使用false作为第3个参数调用
setval
,允许我们指定"next value to use":这勾选了我的所有方框:
避免硬编码实际的序列名称
正确处理空表
处理具有现有数据的表,并且不会在序列中留下空洞
最后请注意,
pg_get_serial_sequence
仅在序列归列所有时才有效 . 如果将递增列定义为serial
类型,则会出现这种情况,但是如果手动添加序列,则必须确保也执行ALTER SEQUENCE .. OWNED BY
.即如果
serial
类型用于表创建,这应该都可以工作:但是如果手动添加序列:
这个答案是毛罗的副本 .
Source - Ruby Forum
shortest and fastest 方式:
tbl_id
是表tbl
的serial列,从序列tbl_tbl_id_seq
(这是默认的自动名称)中提取 .如果您不必采用默认格式),请使用pg_get_serial_sequence():
这里没有一个错误的错误 . Per documentation:
大胆强调我的 .
并发
但是,在上述查询中,并没有防止并发序列活动或写入表 . 如果这是相关的,您可能在独占模式下 lock the table . 当您尝试同步时,它可以防止并发事务写入更高的数字 . (它还会暂时阻止无害的写入而不会弄乱最大数量 . )
但它没有考虑到客户端可能提前获取序列号而没有主表上的任何锁定(但可能发生) . 为了实现这一点,也只增加序列的当前值,而不是减少它 . 它可能看起来很偏执,但这符合序列的本质和防御并发问题 .
我的版本使用第一个,有一些错误检查...
在我还没有尝试过代码之前:在下面我发布了用于我的电脑上的Klaus和user457226解决方案的sql-code的版本[Postgres 8.3],只为Klaus one和我的版本做了一些小调整对于user457226一个 .
克劳斯解决方案:
user457226解决方案:
重置所有序列,没有关于名称的假设,除了每个表的主键是“id”:
如果在加载自定义SQL数据进行初始化时看到此错误,则另一种避免这种情况的方法是:
而不是写:
从初始数据中删除
id
(主键)这使Postgres序列保持同步!
从公共重置所有序列
我花了一个小时试图让djsnowsill的答案与使用混合案例表和列的数据库一起工作,然后由于Manuel Darveau的评论最终偶然发现了解决方案,但我想我可以让每个人都清楚一点:
这有以下好处:
不假设ID列以特定方式拼写 .
不假设所有表都有序列 .
适用于混合大小写表/列名称 .
使用格式更简洁 .
要解释一下,问题是
pg_get_serial_sequence
需要字符串来计算出你所指的内容,所以如果你这样做:这是使用格式字符串中的
''%1$I''
实现的,''
使得撇号1$
表示第一个arg,I
表示引号把它们放在一起
将修复给定表的'
id'
序列(例如,通常需要django) .SELECT setval...
使JDBC变成了bork,所以这里有一种与Java兼容的方法:重新检查公共模式函数中的所有序列
试试reindex .
更新:正如评论中所指出的,这是对原始问题的回答 .
此命令仅用于更改postgresql中自动生成的键序列值
代替零,您可以输入要重新启动序列的任何数字 .
默认序列名称将为
"TableName_FieldName_seq"
. 例如,如果表名为"MyTable"
且字段名称为"MyID"
,那么您的序列名称将为 "MyTable_MyID_seq" .答案与@ murugesanponappan的答案相同,但他的解决方案中存在语法错误 . 你不能在
alter
命令中使用子查询(select max()...)
. 因此,您必须使用固定数值,或者需要使用变量代替子查询 .当使用实体框架创建数据库然后使用初始数据为数据库播种时,这个问题发生在我身上,这使得序列不匹配 .
我通过创建在播种数据库后运行的脚本来解决它:
要重新启动所有序列为1,请使用:
Klaus的答案是最有用的,有点想念的execpt:你必须在select语句中添加DISTINCT .
但是,如果您确定没有表列名称可以等效于两个不同的表,您还可以使用:
这是user457226解决方案的扩展,适用于某些感兴趣的列名称不是“ID”的情况 .
我建议在postgres wiki上找到这个解决方案 . 它会更新表的所有序列 .
如何使用(来自postgres wiki):
将其保存到文件中,例如'reset.sql'
运行文件并以不包含常用 Headers 的方式保存其输出,然后运行该输出 . 例:
例:
原始文章(也修复序列所有权)here
又一个plpgsql - 仅在
max(att) > then lastval
重置同时注释
--execute format('alter sequence
行将给出列表,而不是实际重置值