Re: Per-query local timezone - Mailing list pgsql-general

From Mark Morgan Lloyd
Subject Re: Per-query local timezone
Date
Msg-id it7ud5$9no$1@pye-srv-01.telemetry.co.uk
Whole thread Raw
In response to Re: Per-query local timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> John R Pierce <pierce@hogranch.com> writes:
>> On 06/14/11 2:40 AM, Mark Morgan Lloyd wrote:
>>> The development environment I'm working with uses short-lifetime
>>> sessions, and it's proving difficult to get a set command and a query
>>> associated with the same handle.
>
>> this environment doesn't support even a transaction?
>
> Sounds kinda broken :-( ... but maybe Mark could wrap the operations
> he needs into custom functions.

Is always a possibility. The problem is that particular component I'm
using conflates the open and issue-query operations and has an implicit
transaction, the developers are aware that this has undesirable
implications.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Per-query local timezone
Next
From: "erwin@darwine.nl"
Date:
Subject: Re: psql reports back wrong number of affected rows.