Обсуждение: PostgreSQL equivalent of UTL_HTTP

Поиск
Список
Период
Сортировка

PostgreSQL equivalent of UTL_HTTP

От
aditya desai
Дата:
Hi,
We are migrating Oracle to PostgreSQL. We need the equivalent of UTL_HTTP.
How to invoke Web service from PostgreSQL.

Also please let me know the PostgreSQL equivalents of below Oracle utilities..

utl.logger,UTL_FILE,UTL_SMTP

Regards,
Aditya.


Re: PostgreSQL equivalent of UTL_HTTP

От
Pavel Stehule
Дата:
Hi

st 11. 8. 2021 v 20:57 odesílatel aditya desai <admad123@gmail.com> napsal:
Hi,
We are migrating Oracle to PostgreSQL. We need the equivalent of UTL_HTTP.
How to invoke Web service from PostgreSQL.

Also please let me know the PostgreSQL equivalents of below Oracle utilities..

utl.logger,UTL_FILE,UTL_SMTP


You can use an routines in untrusted PLPerl or untrusted PLPython, but these routines can be really unsafe (due possibility to break signal handling).

Personally, I think using http access in stored procedures is a very bad idea - access from transactional to non-transactional (and possibly pretty slow) environments creates a lot of ugly problems. Stored procedures are great technology with a pretty bad reputation, and one reason why is usage of this technology for bad cases.

I think this mailing list is wrong for this kind of question. There is no relation to performance.

Regards

Pavel





Regards,
Aditya.


Installation of PostgreSQL on fedora zVM

От
Manish Lad
Дата:
Hi All, 

Have anyone tried to install PostgreSQL on the VM provisioned on IBM Z? 

If yes please could you share the installation instructions or point to the blog etc.

Thanks in advance. 

Thanks & Regards,
Manish