Re: [JDBC] Transaction size limit & Data Truncation

2001-09-14 Thread Rene Pijlman
You wrote: >> I can see that very long transaction are not supported. Where or how did you see that? >As far as transaction is concerned, my question was if there is any limit >to the number of statements (select/insert/update) that can be >in one single transaction. >Is is possible postgresql

Re: [JDBC] Transaction size limit & Data Truncation

2001-09-14 Thread Alexaki Sofia
Thanks for your reply. As far as transaction is concerned, my question was if there is any limit to the number of statements (select/insert/update) that can be in one single transaction. Is is possible postgresql buffer size influence transaction limit? I had a transaction with thousands of stat

Re: [JDBC] Transaction size limit & Data Truncation

2001-09-13 Thread Barry Lind
Alexaki, I am unsure what you mean by very long transaction. A transaction is defined by issueing a 'begin' statement, followed sometime later by a 'commit' or 'rollback'. Therefore a long transcation would imply a long period of time between the begin and the commit or rollback. There is

[JDBC] Transaction size limit & Data Truncation

2001-09-13 Thread Alexaki Sofia
Hello, I use the PostgreSQL 7.0.2 JDBC Driver. I can see that very long transaction are not supported. Is there any limit in the transaction size? My second querstion is about data truncation. As I can see postgresql JDBC driver doesn't report a DataTruncation warning when a data value is trun