From: | Jörg Schulz <jschulz(at)sgbs(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: different transaction handling between postgresql and oracle/mysql |
Date: | 2003-07-14 08:17:40 |
Message-ID: | 200307141017.40731.jschulz@sgbs.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> ... I have this feeling the reason Oracle gives this result may
> be again because transactions have been switched off!
This snippet comes from the Oracle console:
(table name is "a" not "test" / messages are in german)
SQL> show autocommit;
autocommit OFF
SQL> select * from a;
A
----------
1
SQL> commit;
Transaktion mit COMMIT abgeschlossen.
SQL> insert into a values (2);
1 Zeile wurde erstellt.
SQL> insert into a values (3);
1 Zeile wurde erstellt.
SQL> insert into a values (1);
insert into a values (1)
*
FEHLER in Zeile 1:
ORA-00001: Verstoß gegen Eindeutigkeit, Regel (KLAX.SYS_C001753)
SQL> insert into a values (4);
1 Zeile wurde erstellt.
SQL> commit;
Transaktion mit COMMIT abgeschlossen.
SQL> select * from a;
A
----------
1
3
4
2
SQL>
> ...If you want the
> second result in Postgres just switch auto-commit on
Maybe I have to do other things in another table. So I must
do it inside a transaction.
Jörg
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2003-07-14 08:34:55 | Re: different transaction handling between postgresql and |
Previous Message | Adam Witney | 2003-07-14 08:06:10 | Re: OS X installation with readline support |