I apologise if I'm misusing the ticket system by posting what is essentially an enquiry or a feature request, but there isn't a message board for technical discussion that do not relate to fixing bugs, which perhaps there should be. I'd certainly be an active participant in such a message board if there was.
I'm implementing a distributed database. I need to reconcile two tables, one in one database, the other in another, on a remote server. If they were in the same database, I might perform an EXCEPT based enquiry, then increment through the results, updating the second table (well, actually, I'd probably do a union, but that's probably not possible at all with remote databases, and as such doesn't illustrate my point.)
Here's the SQL:
SELECT *
FROM NEWTABLEMASTER
EXCEPT
SELECT *
FROM OLDTABLESLAVE;
I now increment through the std::vector-style container class, "result", updating the second database's OLDTABLESLAVE table as I increment, until the two databases have been reconciled.
I want to have two concurrent database connections, one a localhost connection, the other a remote connection, each with a table that is reconciled with the other table in this way (or even in another, more efficient way that hasn't occurred to this SQL novice), using libpqxx. Is this possible?
Regards,
Peter Geoghegan
