On Mon, Dec 13, 2004 at 17:04:17 +0100,
[EMAIL PROTECTED] wrote:
> Thank you for your answer. I think it's very interesting behaviour. Is
> it a feature or bug ?
Until version 8 (which is in release candidate status now), there was
no way to recover from an error within a transaction other than
Thank you for your answer. I think it's very interesting behaviour. Is
it a feature or bug ?
I have try this my jUnit test for another DB systems (e.g. Oracle 9i,
MS SQL Server 2000, MySQL, DB2, Sybase, SAP DB) and it works for each of
these databases (it was possible tu run next command succes
If you attempted the inserts within a single transaction and any of
them fail, they will all fail. The server will automatically undo any
and all changes made by the transaction, and any further steps in the
transaction will simply result in the error message you are getting.
You will not be
On Wed, Dec 08, 2004 at 14:50:04 +0100,
Julian Legeny <[EMAIL PROTECTED]> wrote:
> Hello,
>
>Then I want to process command
> select count(*) from UNIQUE_COLUMN_TEST
>that I want to know how many records was already inserted before id
>faied.
>
>But when I try to process t
Hello,
I have a following table with unique column:
CREATE TABLE UNIQUE_COLUMN_TEST (
TEST_ID INTEGER,
CONSTRAINT TEST_ID_UQ UNIQUE (TEST_ID)
)
Then I insert few records into the table, and then I try to insert
duplicate record. There is correct error occured:
org.p
Hello,
I'm using postgreSQL 8.0 beta1 and JDK 1.4.
I have following problem:
I have create test table that contains only unique column :
CREATE TABLE UNIQUE_COLUMN_TEST (
TEST_ID INTEGER,
CONSTRAINT TEST_ID_UQ UNIQUE (TEST_ID)
)
Within one transaction I have insert a few records int
