Re: Reading PG data from MySQL stored procedure
От | Craig Ringer |
---|---|
Тема | Re: Reading PG data from MySQL stored procedure |
Дата | |
Msg-id | 4EA0D78F.4090403@ringerc.id.au обсуждение исходный текст |
Ответ на | Re: Reading PG data from MySQL stored procedure ("Gauthier, Dave" <dave.gauthier@intel.com>) |
Ответы |
Re: Reading PG data from MySQL stored procedure
|
Список | pgsql-general |
On 10/21/2011 03:56 AM, Gauthier, Dave wrote: > The software system they are being forced to use gives them the ability to send queries to a MySQL which has already beenconnected to. However, they do have the authority to add things to that DB, like stored procedures. This user isn'tcoding anything per-se, they're just using the interface provided. But they can "call" a stored procedure/functionbecause that's ligit sql. The data that flows from that goes into other parts of the system for reporting,etc... . AFAIK, the only way you'd be able to get from MySQL to Pg directly would be to install a user-defined function written in C that used libpq to connect to Pg. You can't do that over a basic connection to MySQL, you need the ability to install binaries on the server. The system is too locked down to permit what you want to do on the MySQL end. You'd have to make a connection to Pg from the client side, extract the data you wanted and send it down the connection "handle" for MySQL that you already have. There's a bit too much hand-waving and not enough specifics about language, environment, etc to say anything more. Is this some kind of report-writing system? A RAD environment? What? -- Craig Ringer
В списке pgsql-general по дате отправления: