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
it's existence if it belongs to
public schema or access it using fully qualified name scheme.
Steven
從我的 Samsung Galaxy 智慧型手機傳送。
原始訊息 自： PAWAN SHARMA 日期： 2017/6/2
16:16 (GMT+08:00) 至： pgsql-general@postgresql.org 主旨： [GENERAL] Oracle
database into PostgreSQL using Ora2PG tool
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
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
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 UPDATE OF JOB_ID, DEPARTMENT_ID ON EMPLOYEES
FOR EACH ROW
BE
12 matches
Mail list logo
