current transaction is aborted, commands ignored until end of transaction block

[PAscal L]

would a savepoint be defined before each statement execution
to be more oracle friendly
and to behave like edb_stmt_level_tx=true in EDM oracle mode ?

thanks for your answer

Regards
PAscal

[Pavel Stehule]

Hi

2015-11-26 21:36 GMT+01:00 PAscal L <legrand...@hotmail.com>:

would a savepoint be defined before each statement execution
to be more oracle friendly
and to behave like edb_stmt_level_tx=true in EDM oracle mode ?

ON_ERROR_ROLLBACK = 'on'

http://blog.endpoint.com/2015/02/postgres-onerrorrollback-explained.html

Regards

Pavel

 

thanks for your answer

Regards
PAscal

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To post to this group, send email to orafce-...@googlegroups.com.
Visit this group at http://groups.google.com/group/orafce-general.

[PAscal L]

Very interesting !
Thanks

Note:

ON_ERROR_ROLLBACK = 'on'

apply in psql client only

when
SET edb_stmt_level_tx TO on;

seems to work at db level (it works for me with a standard jdbc client tool SQLeo and the pg jdbc standard jar)

[Pavel Stehule]

I don't know - edb is Postgres fork with lot of differences

Pavel