Page 1 of 1
PostgreSQL Unidirectional Query
Posted: Sat 24 Jan 2009 11:16
by rant801601
Is this proper behavior for Query. When Query.Open I get error message
Active transaction required for using FetchAll = False mode.
From this I can see I have to do Connection.StartTransaction before Query.Open and it works. Can you please explain why. Is this Postgre specific behaviour ?
Posted: Thu 29 Jan 2009 10:24
by Plash
This is specific to PostgreSQL server. It does not support FetchAll = False mode without an active transaction.
Posted: Thu 29 Jan 2009 10:41
by rant801601
This specific behavior means I can't use same code for different databases. I think this could be handled internally. If I would like to migrate a large project 300+ units to UniDAC (dbExpress + Oracle) it will break almost all code.
Posted: Fri 30 Jan 2009 11:51
by Plash
We'll consider possibility to implement this feature in one of the next UniDAC versions.
Posted: Fri 30 Jan 2009 13:43
by rant801601
Just to be sure I must ask you another question about memory usage. With UniDirectional=True Query I expect nothing is cached in client side. When testing with Firebird I don't see memory increase but with Postgre memory usage goes to 24 Mb (fetching 1 million records). Is there something else I must do ?
Posted: Mon 09 Feb 2009 11:55
by Challenger
We could not reproduce the problem. We have answered you by mail.