| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Sachin Srivastava *EXTERN*" <ssr(dot)teleatlas(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Function error |
| Date: | 2016-01-14 13:40:36 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B537C0497@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sachin Srivastava wrote:
> In my function the problem is that global variables defined inside the function.
> These variables are visible to functions defined inside a function.
> If we move these inner functions to outside of the main function,
> they will lose the visibility of the global variables.
> So I think that's why we have to correct this functions rather then creating it as individual.
I see.
You'll have to rewrite the functions then, probably by passing the shared
values as parameters instead of having them in global variables.
> We have migrated our data from Oracle to Postgres through ORA2PG Tool
> after that we are getting this error for this function.
ora2pg cannot translate all PL/SQL code, you have to be prepared to rewrite
most nontrivial functions.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-01-14 15:00:44 | Re: Why PG uses nested-loop join when no indexes are available? |
| Previous Message | Steven Livingstone | 2016-01-14 10:01:53 | Re: master slave failover - secondary slaves |