Hi all,
Please find the procedure and trigger which took more time when we try
to update value in table through Procedure.
CREATE OR REPLACE FUNCTION procname1(args)
RETURNS void AS
$BODY$
DECLARE
{
---
Some code blocks
---
}
BEGIN
--> to here it is executing fastly after reaches thi
hello
Are you sure, so you don't call trigger recursion?
Regards
Pavel Stehule
2008/7/14 Praveen <[EMAIL PROTECTED]>:
>
> Hi all,
> Please find the procedure and trigger which took more time when we try to
> update value in table through Procedure.
>
> CREATE OR REPLACE FUNCTION procname1(args
Yes , I am sure it is not trigger recursion.
- Original Message -
From: "Pavel Stehule" <[EMAIL PROTECTED]>
To: "Praveen" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2008 3:03 PM
Subject: Re: [PERFORM] Trigger is not firing immediately
hello
Are you sure, so
Hi guys !!!
Sorry for the wrong spelling. =)
I could see that PostgreSQL will support my application, but i have to do a
good configuration on my server.
Thanks for answers, now i will look for informations about PostgreSQL on
OpenSolaris 2008.05
Have a nice week,
Levi
2008/7/4 Chris Browne <[E
On Sun, Jul 13, 2008 at 11:59 PM, Ramasubramanian
<[EMAIL PROTECTED]> wrote:
>
> Hi All,
> I am having a trigger in table, If i update the the table manually it is
> not taking time(say 200ms per row), But if i update the table through
> procedure the trigger is taking time to fire(say 7 to 10
On Fri, 11 Jul 2008, Jeffrey Baker wrote:
Their firmware is, frankly, garbage. In more than one instance we
have had the card panic when a disk fails, which is obviously counter
to the entire purpose of a RAID. We finally removed the Areca
controllers from our database server and replaced them
