So the best option is to send the data to a table and then with an cronjob I verify if it is data to send to the MySQL database.
Best Regards,
André.
On Mon, Apr 19, 2010 at 10:09 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
> Thanks for the reply.yes. you can store values to some stack table (via trigger) and later
>
> I can't install languages. The database is in a shared hosting.
>
> There are other solutions?
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.stehule@xxxxxxxxx>
> wrote:
>>
>> Hello
>>
>> 2010/4/19 Andre Lopes <lopes80andre@xxxxxxxxx>:
>> > 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é
>> >
>
>
