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

Re: Transaction size limit & Data Truncation

From: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Transaction size limit & Data Truncation
Date: 2001-09-14 06:49:09
Message-ID: Pine.GSO.4.33.0109140924170.8646-100000@athena.ics.forth.gr (view raw or flat)
Thread:
Lists: pgsql-jdbc
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 statements that I neeeded
to split it into a number smaller transaction in order to be able to
store it.

>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
>no limit that I am aware of on the length in time for a transaction.

>n your second questions, what sort of data truncation are you talking
>about?  Could you provide an example?

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.

Alexaki Sofia wrote:
> 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 truncated. Is there any other way to detect data truncation?
>
> Thanks in advance for your help.


In response to

Responses

pgsql-jdbc by date

Next:From: Peter T MountDate: 2001-09-14 08:55:06
Subject: Fw: JDBC Bug Report
Previous:From: Glenn R. KronschnablDate: 2001-09-14 03:58:23
Subject: Re: Using boolean '1' in jdbc2

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