On Mon, Feb 1, 2010 at 1:30 PM, Muhammad Isnaini <[email protected]> wrote: > >> # 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 ).
Hi, I do not directly use a Serial data type. I would like to understand the reasons that are behind your advice. Could you explain why? Thanks, Christophe Philemotte _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
