Re: Changing behavior of BEGIN...sleep...do something...COMMIT - Mailing list pgsql-hackers

From Olleg Samojlov
Subject Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Date
Msg-id b68phh$2gmi$1@news.hub.org
Whole thread Raw
In response to Changing behavior of BEGIN...sleep...do something...COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Changing behavior of BEGIN...sleep...do something...COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

Tom Lane wrote:
> It seems to me that it'd be fairly easy to make BEGIN cause only
> a local state change in the backend; the actual transaction need not
> start until the first subsequent command is received.  It's already
> true that the transaction snapshot is not frozen at BEGIN time, but
> only when the first DML or DDL command is received; so this would
> have no impact on the client-visible semantics.  But a BEGIN-then-
> sleep-for-awhile client wouldn't interfere with VACUUM anymore.

As I can remember, already, when autocommit off transaction begin with 
first DML or DDL command. May be better change client to use autocommit 
off mode?

-- 
Olleg Samojlov



pgsql-hackers by date:

Previous
From: "Steve"
Date:
Subject: SQL Query to get Column constraints
Next
From: Andrew Gemmell
Date:
Subject: gmake does not finish on default slackware 9 (or 8.1) install