[Pgpool-general] Pgpool-general Digest, Vol 63, Issue 1

[Muhammad Isnaini]

> # Force to flush current value of sequences to xlog
> psql -p $port -t -c 'SELECT datname FROM pg_database WHERE
> NOT
> datistemplate AND datallowconn' template1|
> while read i
> do
>  if [ "$i" != "" ];then
>    psql -p $port -c "SELECT setval(oid,
> nextval(oid)) FROM pg_class
> WHERE relkind = 'S'" $i
>  fi
> done

You should avoid using Serial, Auto Increment ( MySQL ).