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 Newsgroups: comp.databases.postgresql Subject: Re: serializable transactions across partitioned table Date: Sat, 17 May 2014 12:52:08 +0200 Lines: 14 Message-ID: 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 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