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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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