A big part of thisinquiry has to do with feasibility. Another option is to approach those who control that system which the user has to use and get them to be more accommodating with regard to attaching to more than one DB and realizing that there are other DB engines than MySQL. Armed with the info you guys have given me, I will propose to them that they ask their app provider the means to attach to multiple ODBC served DBs (this thing is a Windows based app). That way they can use MySQL and PG and whatever else they might have to deal with in the future. Many thanks for the input. As I said, it was a long shot. So I got what I expected. At least now I can tell them that I am not alone is my opinion that getting PG date througn MySQL is a bad idea. Thanks Again! -----Original Message----- From: Craig Ringer [mailto:ringerc@xxxxxxxxxxxxx] Sent: Thursday, October 20, 2011 10:23 PM To: Gauthier, Dave Cc: Merlin Moncure; pgsql-general@xxxxxxxxxxxxxx Subject: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
