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

[Christophe Philemotte]

On Mon, Feb 1, 2010 at 1:30 PM, Muhammad Isnaini <moch_isnaini at yahoo.com> 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