PostgreSQL sources do not have the procedure option within Yellowfin

Pratap Singh shared this idea 17 months ago
Completed

PostgreSQL sources do not have the procedure option within Yellowfin. From what we can see this is was due to a change in PostgreSQL JDBC driver: https://github.com/pgjdbc/pgjdbc/issues/1340

In Postgres FUNCTIONs return resultsets, where in other databases, PROCEDUREs do that.

Until recently the getProcedures() call in the PostgreSQL JDBC driver would return functions from Postgres. This allowed functions that returned a resultset to be accessed by Yellowfin.

However, a recent change to the JDBC driver has stopped functions being returned by getProcedures(). This is generally returning nothing, and why the procedures option is not shown in Yellowfin.

We need to change Yellowfin to support Functions to be able to support the functionality that we used to have.

Replies (5)

photo
1

Hi Pratap,

I hope all is well,

I have since raised this as an Enhancement with our Development team. I will update as and when I can.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

I come with news that we have since implemented this Enhancement request. We can find this within our 9.10 release. Because of this I will now mark this ticket as Completed.

Going forward if you have any issues, please let me know. I would be more than happy to assist where I can.

Regards,

Mark

photo
1

Hi Mark,
let me know if there is any particular way to define function/procedure in postgre , we tried with 9.12 but not able to go through.
Regards
Pratap

photo
1

Hi Pratap,

Are you free for a remote session so we can go over this?

Let me know your availability I am UK based (as you know) and can make myself available from tomorrow between the hours of 09:00-14:30 UK Time.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

I just want to inform you that we have a UK Bank Holiday here in the UK on Monday, 26th August so scheduling a remote session in would work for me as of Tuesday. Let me know the date/time so we can connect.

Regards,

Mark

photo
1

Hi Mark,
We can connect at 9:00 AM UK Time (1:30 PM IST) on Tuesday.
Regards
Pratap

photo
1

Hi Pratap,

I have scheduled this in. I have sent this invite to your email address.

Please inform me of receiving this.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

Unfortunately I have to cancel today at 09:00, however we can re-schedule for the same time tomorrow if this works for you?

Please let me know.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

I just want to touch base to see if we can get this picked up one of the days this week, I only as as I have some annual leave as of next week so I would like to get this addressed.

If you can get back to me I would appreciate this a lot.

Regards,

Mark

photo
1

Hi Pratap,

I just want to touch base to see if you are available for a call tomorrow? As mentioned I am on annual leave as of next week so this might be a case of holding back until I am back or have this escalated. If you can let me know that would be great.

Regards,

Mark

photo
1

Hi Mark,
We will have this call once you are back from leave.
Thanks & Regards
Pratap

photo
1

Hi Pratap,

Thank you for your patience with this whilst I was away on Annual Leave. Going forward can I ask of your availability for a remote one of the days this week?

I can make myself available between the hours of 09:30-14:00 (UK), Wednesday-Friday.

Let me know.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

I just want to touch base to see if we can schedule a remote session. Unfortunately I can't connect tomorrow, however any of the days next week between the hours of 09:30-14:00 UK would work well with me.

I look forward to your response.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

I just want to touch base to see if we can schedule something in this week. Unfortunately I can't attend any meetings today (fully booked), however Wednesday onwards I am free. Please let me know what works best for you.

Regards,

Mark

photo
1

Hi Pratap,

I hope all is well,

I would like to propose a remote session for tomorrow (Friday) between the hours of 09:30-14:00 UK Time. If you can confirm exact time that suits you, that would be great.

I look forward to your response.

Regards,

Mark

photo
1

Hi Pratap,

I have gone ahead and marked this as Completed, if you want to re-open, please do not hesitate to do so, I would be more than happy to assist where I can.

Regards,

Mark

photo
Leave a Comment
 
Attach a file