search cancel

Custom GEL Script Does Not Work for Update Statement in PostgreSQL Database

book

Article ID: 203422

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Create a custom GEL script with an update statement such as:

update odf_ca_project p 
set p.attribute1 = p.attribute2

 

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Cause

PostgreSQL does not accept aliases, there the alias would need to be removed from the update statement.

Resolution

For example, modify the statement from:

update odf_ca_project p 
set p.attribute1 = p.attribute2

to

update odf_ca_project 
set attribute1 = attribute2