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 |
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 |