Search Postgresql Archives

Re: How to know if an INSERT is done inside a function?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
look at this page of the documentation of postgres http://www.postgresql.org/docs/current/static/plpgsql-statements.html
there explain some ways to know
the effect of a SQL command.

Regards.

2010/7/4 Andre Lopes <lopes80andre@xxxxxxxxx>
Hi,

The function will run in the php-cli, in a CronJob, it is not for use in a PHP webpage. I think doesn't matter the extra time that takes to run.

Best Regards,



On Sun, Jul 4, 2010 at 4:11 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
2010/7/4 Merlin Moncure <mmoncure@xxxxxxxxx>:
> On Sun, Jul 4, 2010 at 7:25 AM, Andre Lopes <lopes80andre@xxxxxxxxx> 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
>



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux