Hi,
I have a function, at the end I need to know if the INSERTS have run
successfully or not.
Here is the function:
[code]
CREATE OR REPLACE FUNCTION "apr_insert_utilizador_ap"
(IN ppgroup_id int4,
IN ppip_address char,
IN ppusername varchar,
IN pppassword varchar,
IN ppemail varchar,
IN ppactiv
Hello
every unsuccessful SQL command raises exception in PL/pgSQL. So if
your function is finished without exception, then INSERT is ok.
Regards
Pavel Stehule
2010/7/4 Andre Lopes :
> Hi,
>
> I have a function, at the end I need to know if the INSERTS have run
> successfully or not.
>
> Here is
Hi,
Thanks for your reply.
Yes, in the Postgre command line I see the exception, the problem is that
I'am using this function in a PHP code. I need send the value "1" to the OUT
parameter if the function is successful or send the value "0" to the OUT
parameter if the function not runs successful.
2010/7/4 Andre Lopes :
> Hi,
>
> Thanks for your reply.
>
> Yes, in the Postgre command line I see the exception, the problem is that
> I'am using this function in a PHP code. I need send the value "1" to the OUT
> parameter if the function is successful or send the value "0" to the OUT
> parameter
Great! That is what I need!
Thank you Pavel.
Best Regards,
On Sun, Jul 4, 2010 at 12:20 PM, Pavel Stehule wrote:
> 2010/7/4 Andre Lopes :
> > Hi,
> >
> > Thanks for your reply.
> >
> > Yes, in the Postgre command line I see the exception, the problem is that
> > I'am using this function in a PH
On Sun, Jul 4, 2010 at 7:25 AM, Andre Lopes 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.
merlin
--
Sen
Several times I wanted to "extend" some of the postgres objects, like roles
or functions. For example, sometimes you want to add extra attributes to
roles, which are application dependent. Or sometimes you want to store
functions and reference them in your custom tables, without losing
referent
Hi,
I need to use an Forum Software. There is any Open Souce Forum Script using
PostgreSQL?
Best Regards,
André.
On 7/4/2010 8:10 AM, Andre Lopes wrote:
I need to use an Forum Software. There is any Open Souce Forum Script
using PostgreSQL?
We use jForum.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsq
On Sun, Jul 04, 2010 at 03:10:36PM +0100, Andre Lopes wrote:
> Hi,
>
> I need to use an Forum Software. There is any Open Souce Forum Script using
> PostgreSQL?
phpBB3 off the top of my head.
--
"A search of his car uncovered pornography, a homemade sex aid, women's
stockings and a Jack Ru
On Sun, Jul 4, 2010 at 3:22 PM, CaT wrote:
> On Sun, Jul 04, 2010 at 03:10:36PM +0100, Andre Lopes wrote:
>> Hi,
>>
>> I need to use an Forum Software. There is any Open Souce Forum Script using
>> PostgreSQL?
>
> phpBB3 off the top of my head.
If using the one-click PostgreSQL installers, you ca
On 4 July 2010 15:22, CaT wrote:
> On Sun, Jul 04, 2010 at 03:10:36PM +0100, Andre Lopes wrote:
>> Hi,
>>
>> I need to use an Forum Software. There is any Open Souce Forum Script using
>> PostgreSQL?
>
> phpBB3 off the top of my head.
>
I found phpBB3 unusable for PostgreSQL last time as if you t
2010/7/4 Merlin Moncure :
> On Sun, Jul 4, 2010 at 7:25 AM, Andre Lopes 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 ex
Le 04/07/2010 16:10, Andre Lopes a écrit :
> Hi,
>
> I need to use an Forum Software. There is any Open Souce Forum Script
> using PostgreSQL?
>
Fluxbb (http://fluxbb.org/) works great with PostgreSQL. We use it at
http://forums.postgresql.fr and we're really happy with it.
--
Guillaume
http
Andre Lopes wrote:
Hi,
I need to use an Forum Software. There is any Open Souce Forum Script
using PostgreSQL?
Best Regards,
André.
Zforum does, but you will need to install Zope to run it.
Garry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
> I need to use an Forum Software. There is any Open Souce Forum Script using
> PostgreSQL?
We use SimpleMachines SMF.
cheers
®
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 wrote:
> 2010/7/4 Merlin Moncure :
> > On Sun, Jul 4, 2010 at 7:25 AM, Andre Lopes
>
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
> Hi,
>
> The function will run in the php-cli, in a CronJob, it is not for use
On 04/07/10 21:43, Davor J. wrote:
> PS using inheritance in this scenario is problematic.
Yep. Just one issue is that roles are cluster-wide, whereas tables are
visible only inside a single database.
I generally use the role mechanism as-is, granting users access to roles
that control particul
19 matches
Mail list logo
