Re: Reading PG data from MySQL stored procedure

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 been connected to. However, they do have the authority to add things to that DB, like stored procedures. This user isn't coding anything per-se, they're just using the interface provided. But they can "call" a stored procedure/function because 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