| 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: | Whole Thread | Raw Message | 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 |