DROP SEQUENCE foo;
CREATE SEQUENCE foo;
\echo These 3 LSNs should be the same
select nextval('foo'), pg_current_xlog_insert_location();
select nextval('foo'), pg_current_xlog_insert_location();
select nextval('foo'), pg_current_xlog_insert_location();

ALTER SEQUENCE foo USING gapless;
\echo These 3 LSNs should be all be different
select nextval('foo'), pg_current_xlog_insert_location();
select nextval('foo'), pg_current_xlog_insert_location();
select nextval('foo'), pg_current_xlog_insert_location();

ALTER SEQUENCE foo USING local;
\echo These 3 LSNs should be the same
select nextval('foo'), pg_current_xlog_insert_location();
select nextval('foo'), pg_current_xlog_insert_location();
select nextval('foo'), pg_current_xlog_insert_location();