drop database if exists dump_sequence_db;
create database dump_sequence_db;
\c dump_sequence_db
drop schema if exists dumptest cascade;
create schema dumptest;

create role seq_user1 password 'Gauss_234';

create sequence s1;
create large sequence s2;
create table tab_seq(c1 serial, c2 largeserial);

comment on sequence s1 is 'this is a normal sequence';
comment on large sequence s2 is 'this is a large sequence';

grant select on s1 to seq_user1;
grant select on s2 to seq_user1;

\! @abs_bindir@/gs_dump dump_sequence_db -p @portstring@ -f @abs_bindir@/dump_sequence.tar -F t >/dev/null 2>&1; echo $?

drop database if exists restore_sequence_db;
create database restore_sequence_db;

\! @abs_bindir@/gs_restore -d restore_sequence_db -p @portstring@ @abs_bindir@/dump_sequence.tar >/dev/null 2>&1; echo $?


drop database if exists gs_dump_c_t_new;
drop database if exists gs_dump_c_t;
create database gs_dump_c_t;
create database gs_dump_c_t_new;
\c gs_dump_c_t_new
create table table_test(id1 int);
insert into table_test values(generate_series(1,10));
\! @abs_bindir@/gs_dump gs_dump_c_t_new -p @portstring@ -f @abs_bindir@/back.dmp -F c >/dev/null 2>&1; echo $?
\c regression
drop database if exists gs_dump_c_t_new;
\! @abs_bindir@/gs_restore @abs_bindir@/back.dmp -p @portstring@ -d gs_dump_c_t -C -t table_test >/dev/null 2>&1; echo $?
-- not exist
\c gs_dump_c_t
select count(*) from table_test;
-- success
\c gs_dump_c_t_new
select count(*) from table_test;

\c regression

drop database if exists restore_sequence_db;
drop database if exists dump_sequence_db;
drop database if exists gs_dump_c_t_new;
drop database if exists gs_dump_c_t;
drop role seq_user1;