Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #567

Re: serializable transactions across partitioned table

From Robert Klemme <shortcutter@googlemail.com>
Newsgroups comp.databases.postgresql
Subject Re: serializable transactions across partitioned table
Date 2014-05-17 12:52 +0200
Message-ID <btotapF22kjU1@mid.individual.net> (permalink)
References <4d116141-a892-4040-844b-6abac769993c@googlegroups.com>

Show all headers | 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 | NextPrevious 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