Skip site navigation (1) Skip section navigation (2)

Re: Transaction size limit & Data Truncation

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
Cc: Barry Lind <barry(at)xythos(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Transaction size limit & Data Truncation
Date: 2001-09-14 09:53:05
Message-ID: qkk3qts37kltuouk5ulo3c3jou5rsf4rbq@4ax.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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 buffer size influence transaction
>limit?
>I had a transaction with thousands of statements that I neeeded
>to split it into a number smaller transaction in order to be able to
>store it.

What does that mean exactly? What went wrong with the original
long transaction?

Was it an executeBatch() with a lot of statements, or a lot of
individual statements? What version of the PostgreSQL driver and
backend are you running?

>Let's say that I have a field in a table having tha type VARCHAR(100)
>And I store to this field a value having 200 characters. Only the
>first 100 characters of the value will be stored.
>I think that in this case according to JDBC, a Data Truncation warning
>should be  reported.

Our driver does not yet support DataTruncation warnings. That's
documented on http://lab.applinet.nl/postgresql-jdbc/

Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>

In response to

pgsql-jdbc by date

Next:From: Thomas O'DowdDate: 2001-09-14 10:09:16
Subject: Re: Patch to add bytea support to JDBC
Previous:From: Rene PijlmanDate: 2001-09-14 09:47:47
Subject: Re: Fw: JDBC Bug Report

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group