"info" <info(at)el-ixir(dot)com> writes:
> thanks . I have tried to commit the transaction using PREPCOMMIT but the
> statement is not supported by my postgre.
It's spelled COMMIT PREPARED. Perhaps you need to spend more time
reading the fine manual.
regards, tom lane