Re: Request for resolution || Support

On Wed, 24 Jul 2019 at 07:58, jay chauhan <jaychauhan(dot)src(at)gmail(dot)com> wrote:

> Hi Thomas, David/Team,
>
> Thanks you for your response. However we need your confirmation whether my
> Error/issue as mentioned below will be resolved if we upgrade our
> PostgreSQL Version.
>

No, the "issues" that you mentioned will not be automatically resolved by
upgrading to a modern version of PostgreSQL.

You will need to modify your application to use PostgreSQL facilities
properly, such as...

- Not attempting to BEGIN TRANSACTION / COMMIT WORK inside a stored
function.

Per the Fine Documentation:
https://www.postgresql.org/docs/11/plpgsql-structure.html

"Functions and trigger procedures are always executed within a transaction
established by an outer query — they cannot start or commit that
transaction, since there would be no context for them to execute in."

- ERROR: schema "utl_http" does not exist

This is a reference to some Oracle-specific thing that you would need to
reimplement in some fashion for PostgreSQL. A newer version of PostgreSQL
will not somehow draw in Oracle-proprietary features.

If you created a namespace via
create namespace utl_http;

then that particular error message would go away, but it would presumably
be replaced by some other error message as whatever it is that is missing
would still be missing.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"