"info" <info@el-ixir.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