Within a C++ program I essentially do
PgDatabase db ("dbname=sameone")
PgDatabase db2("dbname=sameone")
db.Exec("BEGIN")
db.Exec(select)
loop over db.Tuples() db2.Exec(query involving results from db) do stuff with db2 result
db.Exec("COMMIT")
1) Is the way to keep to results really to have 2 PgDatabase, or is there a simple way of saving the result set before
havingit replaced by the next query?
2) Does that BEGIN/COMMIT just apply to the queries in db, the db2 queries each automatically having their own
transaction?
I know I can experiment to find out, but maybe one of you already knows the
answer...
Cheers,
Patrick