Ok, 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.steh...@gmail.com>wrote: > 2010/4/19 Andre Lopes <lopes80an...@gmail.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.steh...@gmail.com > > > > wrote: > >> > >> Hello > >> > >> 2010/4/19 Andre Lopes <lopes80an...@gmail.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é > >> > > > > > >