execute sql directly ?

[mgmgh]

Hi,
I'm looking for a way to execute postgresql stored procedures from SqlPage.
Like running : call my_proc(param1,param2)
My app needs them because I need to do some long processing and commit frequently inside it. This can not be done in functions, only in procedures.
That will also allow some commands like : refresh materialized view my_view
Is this feature planned ?
I just need a way to run this when user clicks on a button...

[lovasoa]

Hello ! Are you having troubles with using CALL statements ? They should work as well as other statements.

If you want a button that triggers a call, you can write two files:

index.sql

select 'button' as component;
select 'Go !' as title, 'call_proc.sql?x=1&y=2' as link;

call_proc.sql

call my_proc($x, $y);

select 'redirect' as component, '/' as link;

[mgmgh]

Thank you ! It works.
The problem came from inside the procedure, I had to set the date format with "set datestyle='iso,dmy';" in the "on_connect.sql" file because postgresql's "set param=value" statements are not recognized, I suppose they are catched by SqlPage to assign its own variables...
It's not easy to understand the logic of SqlPage at the beginning but I'll continue step by step and I hope I'll achieve my first app this week. Thanks again for creating this kind of tool and responding quickly to the questions.