On Sat, Jun 3, 2017 at 1:48 AM, Igor Neyman wrote:
>
> I wonder, does plpgsql compilation check for existence of the
> add_job_history function or is that a runtime check?
>
>
>
> At runtime.
>
>
Hi Neyman,
Thanks it's done by
I wonder, does plpgsql compilation check for existence of the add_job_history
function or is that a runtime check?
At runtime.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
On 2 June 2017 at 11:57, stevenchang1213 wrote:
>
>
> tell me where this function add_job_history() is?
> Actually, I don't think you can count on ora2pg to transform your pl/sql
> code to plpgsql or other (un)trusted procedural language code. It's not that
> simple!
I wonder, does plpgsql compil
tell me where this function add_job_history() is?Actually, I don't think you
can count on ora2pg to transform your pl/sql code to plpgsql or other
(un)trusted procedural language code. It's not that simple!you can type "\df
add_job_history" in psql session to check it's existence if it belon
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Igor Neyman
Sent: Friday, June 02, 2017 9:45 AM
To: PAWAN SHARMA ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.
Attention: This email was
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of PAWAN SHARMA
Sent: Friday, June 02, 2017 4:17 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.
Attention: This email was sent from someone o
On 2 June 2017 at 04:16, PAWAN SHARMA wrote:
> Hi All,
>
> I am migrating Oracle database into PostgreSQL using Ora2PG tool.
>
> So, I am facing one issue with trigger after generating script output of
> Oracle database.
>
> Oracle :
>
> CREATE OR REPLACE TRIGGER UPDATE_JOB_HISTORY
> AFTER UPD
2017-06-02 11:15 GMT+02:00 PAWAN SHARMA :
>
> On Fri, Jun 2, 2017 at 2:13 PM, Pavel Stehule
> wrote:
>
>> Hi
>>
>> 2017-06-02 10:16 GMT+02:00 PAWAN SHARMA :
>>
>>> Hi All,
>>>
>>> I am migrating Oracle database into PostgreSQL using Ora2PG tool.
>>>
>>> So, I am facing one issue with trigger afte
On Fri, Jun 2, 2017 at 2:13 PM, Pavel Stehule
wrote:
> Hi
>
> 2017-06-02 10:16 GMT+02:00 PAWAN SHARMA :
>
>> Hi All,
>>
>> I am migrating Oracle database into PostgreSQL using Ora2PG tool.
>>
>> So, I am facing one issue with trigger after generating script output of
>> Oracle database.
>>
>> *Or
On Fri, Jun 2, 2017 at 2:20 PM, Andrew Sullivan wrote:
> (Offlist: phone)
>
> It's saying the table isn't there. Is it? Is it maybe spelled
> "EMPLOYEES" (all caps) instead? You need double quotes if so.
>
> A
>
> --
> Andrew Sullivan
> Please excuse my clumbsy thums.
>
> On Jun 2, 2017, at 04
Hi
2017-06-02 10:16 GMT+02:00 PAWAN SHARMA :
> Hi All,
>
> I am migrating Oracle database into PostgreSQL using Ora2PG tool.
>
> So, I am facing one issue with trigger after generating script output of
> Oracle database.
>
> *Oracle : *
>
> CREATE OR REPLACE TRIGGER UPDATE_JOB_HISTORY
> AFTER
11 matches
Mail list logo
