Re: Need help to identify stray row in a table

From: சிவகுமார் மா <masivakumar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help to identify stray row in a table
Date: 2010-04-23 14:42:56
Message-ID: i2u139e14f01004230742pdb86edady317ac3423987d16a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/4/23 Merlin Moncure <mmoncure(at)gmail(dot)com>:
>
> You haven't given enough information to make any sort of reasonable
> diagnosis.  Most people are going to assume the problem is on your end
> but it's possible to know for sure without having the trigger function
> at the very least.
>

Thanks merlin for the reply. There are two functions,

1. for inserts on stock transaction table, calculating value and
inserting in transaction_value table.

2. the other is on transaction_value table itself, to update values of
child transactions of row being inserted/updated/deleted.

The second function is more than 200 lines. I have attached a text
file containing trigger and function code.

Thanks for any insights you can provide.

Best regards,

Ma Sivakumar

மா சிவகுமார்
எல்லோரும் எல்லாமும் பெற வேண்டும்
http://masivakumar.blogspot.com

> merlin
>

Attachment Content-Type Size
transaction-value-trigger-functions.sql application/octet-stream 26.0 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Watson, Nathaniel 2010-04-23 15:03:44 Re: installation on vista
Previous Message Tom Lane 2010-04-23 14:40:36 Re: Upgrading 8.2.4 to 8.3 With TSearch2