Groups > comp.databases.postgresql > #567

Re: serializable transactions across partitioned table

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Robert Klemme <shortcutter@googlemail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: serializable transactions across partitioned table
Date	Sat, 17 May 2014 12:52:08 +0200
Lines	14
Message-ID	<btotapF22kjU1@mid.individual.net> (permalink)
References	<4d116141-a892-4040-844b-6abac769993c@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net VPD7ZTBWfFwTFf6cGr5JvQXopZ3KPb1njQQPZaZfSGqjo1kVI=
Cancel-Lock	sha1:69ELxYPs2df0F5S2dI8m9sF6OhI=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0
In-Reply-To	<4d116141-a892-4040-844b-6abac769993c@googlegroups.com>
Xref	csiph.com comp.databases.postgresql:567

Show key headers only | View raw

On 14.05.2014 19:09, arsenal wrote:

> Do serializable transactions work across a partitioned table?

Generally for transactional integrity it does not matter how many tables 
a transaction touches.  In this scenario however, I'd be more worried 
about the mix of DML (reading and inserting) and DDL (the partitioning, 
which you do not show in your sequence of actions btw.).  I can't offer 
the details but I would check with PostgreSQL docs.

Kind regards

	robert

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

serializable transactions across partitioned table arsenal <naren.chainani@gmail.com> - 2014-05-14 10:09 -0700
  Re: serializable transactions across partitioned table Jasen Betts <jasen@xnet.co.nz> - 2014-05-15 12:50 +0000
  Re: serializable transactions across partitioned table Robert Klemme <shortcutter@googlemail.com> - 2014-05-17 12:52 +0200

csiph-web