Skip site navigation (1) Skip section navigation (2)

How to develope an error-handler for a kind of replication

From: DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: How to develope an error-handler for a kind of replication
Date: 2001-07-04 09:21:01
Message-ID: 006b01c1046a$a4d43660$01011eac@irina (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,
I use postgresql 7.0.2 as backend and MsAccess as frontend. In order to improve performance I use local Access tables and a copy of these tables on postgresql side. This means, that when I update some rows in the Access tables I have to synchronise the server tables and to develope an error-handler for any cases. In the docu I read, that every SQL query is executed in a transaction, this means that every update or insert is completed or isn't done. Now I assume, that an error occurs, because the server has some problems, or the network or, or, or.....How can I find out on Access side, wheter the transaction was made or not? Did the error occur befor or after the transaction?

Please, can someone show me, where I can find some information, hints, examples,.... how to realize this Error-handler ?

Thanks for your help
Irina
E-Mail: i(dot)hasenoehrl(at)aon(dot)at

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-07-04 10:25:34
Subject: RE: odbc with MS-Query
Previous:From: Paul HaddonDate: 2001-07-04 02:31:09
Subject: Re: Postgresql/Cold Fusion cfinsert date problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group