Am Freitag, 15. Juli 2005 19:19 schrieb Tom Lane:
Janning Vygen [EMAIL PROTECTED] writes:
How can a function determine in which isolation level it runs?
select current_setting('transaction_isolation');
Thank you for the hint.
I didn't find it myself because tab completion on SHOW doesn't
i have a function which calculates some aggregates (like a materialized view).
As my aggregation is made with a temp table and 5 SQL Queries, i need a
consistent view of the database. Therefor i need transaction isolation level
SERIALIZABLE, right? Otherwise the second query inside of the
Janning Vygen [EMAIL PROTECTED] writes:
How can a function determine in which isolation level it runs?
select current_setting('transaction_isolation');
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched