Re: How to call a file from a PlPgsql trigger?

2010/4/19 Andre Lopes <lopes80andre(at)gmail(dot)com>:
> Hi,
>
> Thanks for the reply.
>
> I can't install languages. The database is in a shared hosting.
>
> There are other solutions?

yes. you can store values to some stack table (via trigger) and later
move content of this table to mysql from application. But you can't
execute file from stored procedure as unprivileged user.

Pavel

>
> Best Regards,
>
>
>
> On Mon, Apr 19, 2010 at 10:00 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>>
>> Hello
>>
>> 2010/4/19 Andre Lopes <lopes80andre(at)gmail(dot)com>:
>> > Hi,
>> >
>> > I have an account in a shared hosting account and I can't install any
>> > 3rd
>> > party software.
>> >
>> > I need to send data from a PostgreSQL database to a MySQL database. I
>> > was
>> > thinking of using a trigger. The trigger calling a PHP file to help me
>> > passing the data to the MySQL database.
>>
>> use plperlu instead. You can put connect and transfer of data directly
>> to trigger
>>
>> regards
>> Pavel Stehule
>>
>>
>> http://www.postgres.cz/index.php/PL/Perlu_-_Untrusted_Perl_%28en%29
>> >
>> > It is possible to call a file from a PlPgsql trigger? If yes, how to?
>> >
>> > This is the best way to do this task?
>> >
>> >
>> > PS: Sorry for my english.
>> >
>> > Best Regards,
>> > André
>> >
>
>