Re: How to know if an INSERT is done inside a function? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: How to know if an INSERT is done inside a function?
Date
Msg-id AANLkTimDqlgysUdEbm5aEUmEZXyRCX0BQ6D0A89IyRwF@mail.gmail.com
Whole thread Raw
In response to Re: How to know if an INSERT is done inside a function?  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: How to know if an INSERT is done inside a function?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
2010/7/4 Merlin Moncure <mmoncure@gmail.com>:
> On Sun, Jul 4, 2010 at 7:25 AM, Andre Lopes <lopes80andre@gmail.com> wrote:
>> Great! That [begin exception end] is what I need!
>>
>> Thank you Pavel.
>>
>> Best Regards,
>
> Just a quick heads up: functions with exception handlers tend to be
> more expensive than those without, even if the exception doesn't fire.

yes, better to use prepared statement and read diagnostics info from PHP

Pavel

>
> merlin
>

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Open Source Forum Software using PostgreSQL?
Next
From: Guillaume Lelarge
Date:
Subject: Re: Open Source Forum Software using PostgreSQL?