Re: [GENERAL] Reading PG data from MySQL stored procedure

2011-10-21 Thread Gashi, Ilir
Craig Ringer wrote: 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 procedure

Re: [GENERAL] Reading PG data from MySQL stored procedure

2011-10-20 Thread Craig Ringer
On 10/21/2011 11:21 AM, Gauthier, Dave wrote: 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

Re: [GENERAL] Reading PG data from MySQL stored procedure

2011-10-20 Thread Gauthier, Dave
, 2011 10:23 PM To: Gauthier, Dave Cc: Merlin Moncure; pgsql-general@postgresql.org Subject: Re: [GENERAL] 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

Re: [GENERAL] Reading PG data from MySQL stored procedure

2011-10-20 Thread Craig Ringer
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 an

Re: [GENERAL] Reading PG data from MySQL stored procedure

2011-10-20 Thread Gauthier, Dave
ay, October 20, 2011 3:33 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Reading PG data from MySQL stored procedure On Thu, Oct 20, 2011 at 2:22 PM, Gauthier, Dave wrote: > Here's a real long shot, but what the heck... > > > > I have a user that&#

Re: [GENERAL] Reading PG data from MySQL stored procedure

2011-10-20 Thread Merlin Moncure
On Thu, Oct 20, 2011 at 2:22 PM, Gauthier, Dave wrote: > Here's a real long shot, but what the heck... > > > > I have a user that's using a system that gives him a single MySQL DB handle > to work with.  He must get all his data through this handle.  He wants some > of my PG based data.  Not only

[GENERAL] Reading PG data from MySQL stored procedure

2011-10-20 Thread Gauthier, Dave
Here's a real long shot, but what the heck... I have a user that's using a system that gives him a single MySQL DB handle to work with. He must get all his data through this handle. He wants some of my PG based data. Not only can't he open a new DB handle to my PG DB, but he cannot even run