M
M
mechanicnikodimich2015-10-21 15:36:06
PostgreSQL
mechanicnikodimich, 2015-10-21 15:36:06

ORA-0070 database pg_link does not support some function in this context?

Good day!

When making a request:

UPDATE "public"."education_salary"@PG_LINK s
SET  "stuff_type"='Все учреждения', 
     "val_salary_03"=2
WHERE "report_date" = '01-OCT-2015' and
      "report_org" = 'ГОБУ НПО ВО "ПЛ № 2"'


result:

database pg_link does not support some function in this context.

Wherein:

select *
from  "public"."education_salary"@PG_LINK
where  "report_date" = '01-OCT-2015' and
"report_org" =  'ГОБУ НПО ВО "ПЛ № 2"'


performed without issue.

If you do:

UPDATE "public"."education_salary"@PG_LINK s
SET  "stuff_type"='Все учреждения', 
     "val_salary_03"=2
WHERE "report_date" = '01-OCT-2015'

All OK.

If the additional condition is to put numerical values, then everything is also ok.
The problem is only in varchar (varchar2) - this is from oracle, in pg this column is "character varying".
Am I fooling myself into the dark? Where is wrong?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question