Re: time zone setting.

> Or is the other comment right that sometimes you can include
semicolon-separated actions within a single preparedStatement

I haven't tried it, but I'd trust Oliver on this one. I was thinking of the
underlying wire-level extended query protocol, which requires a single
"statement" per "query".

> Any idea what tokens can appear as the first parameter to set_config? I
tried searching the on-line manual for a list but couldn't find one.

Any server settings (
http://www.postgresql.org/docs/9.0/static/runtime-config.html ) that are
updatable at runtime. For a quick reference, you can run:

select name, short_desc, extra_desc from pg_settings where context = 'user';

(context determines when you can change it).

---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com