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 show it.

But i read the docs again carfully and found "SHOW all" which shows 
"transaction_isolation". I guess it would be fine if the refernce page for 
SHOW and current_setting() list all the possible configuration settings. 

And it should be added in bin/psql/tab-complete.c  but maybe it is already 
done. i dont have the cvs repository source code at hand. Maybe someon can 
pick it up.

kind regards,
janning



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to