Oliver Elphick wrote:
On Wed, 2003-09-03 at 12:19, Martijn van Oosterhout wrote:
If I were doing it would extract the primary key of each table on startup and then change that one line of code to:
os << "SELECT * FROM " << sTable << " WHERE " << prikey << " = currval('" << sTable << "_" << prikey << "_seq')";
You cannot use currval() until you have used nextval() on the same sequence in the same session.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings