Suppose the following:
create table test (a int primary key);
insert into test values (1);
select * from test;
a
=
1
In Postgresql if you do the following in a transaction (either with
autocommit=off or with an explizit begin):
insert into test values (2); -> ok
insert into test values (1); ->
Um, the behaviour you are seeing is what would happen in PostgreSQL if
everything were all in one transaction. What you show for Oracle is what
would happen if each statement were in it's own transaction.
On the postgresql server here, without transactions:
create temp table test (a int primary k
> ... 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