Re: insertion with trigger failed unexpectedly

From: Richard Huxton <dev(at)archonet(dot)com>
To: Anton(dot)Nikiforov(at)loteco(dot)ru, pgsql-general(at)postgresql(dot)org
Subject: Re: insertion with trigger failed unexpectedly
Date: 2004-01-12 10:12:07
Message-ID: 200401121012.07357.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 12 January 2004 05:57, Anton(dot)Nikiforov(at)loteco(dot)ru wrote:
> Dear all,
> i have a problem with insertion data and running post insert trigger
> on it.

> When i'm doing tests - everything is going well, but in
> production when multiple records being inserted losses happend.

OK - there must be something different happening with the live situation.
Better post the CREATE TABLE, trigger code and a sample INSERT.

PS - is the problem:
1. INSERT fails to raw table, and daily is not updated
2. INSERT fails to raw table, but daily is updated
3. INSERT works on raw table but daily is not updated

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Victor Spång Arthursson 2004-01-12 10:45:48 Re: problems dumping from one server 2 another
Previous Message Richard Huxton 2004-01-12 10:04:04 Re: Drawbacks of using BYTEA for PK?