Skip site navigation (1) Skip section navigation (2)

Re: Creating constraint sometime fail in a transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Olivier Hubaut <olivier(at)scmbb(dot)ulb(dot)ac(dot)be>
Cc: PgSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Creating constraint sometime fail in a transaction
Date: 2004-02-20 16:37:13
Message-ID: 28459.1077295033@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
Olivier Hubaut <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> writes:
> So, we're wondering if the action for putting/removing constraint could 
> be executed out of the transaction, so that it may overlaps and crash in 
> such case.

> Does anyone notice the same problem?

When you didn't show us exactly what you're doing or exactly what went
wrong, it's impossible to say ...

			regards, tom lane

In response to

pgsql-sql by date

Next:From: Josh BerkusDate: 2004-02-20 18:53:36
Subject: Re: Row counts/data changes. Any catalog table that has this info?
Previous:From: Richard HuxtonDate: 2004-02-20 15:57:45
Subject: Re: date format in 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group