Question

5
Replies
92
Views
BhargavS Member since 2015 22 posts
Evoke Technologies
Posted: 1 year ago
Last activity: 1 year 5 months ago
Closed
Solved

Error while adding BLOB column

Hi,

I am trying to add BLOB (pzPVStream)column in the table but, we are facing the below error.

There was a problem getting a list: code: 0 SQLState: 42704 Message: ERROR: type "blob" does not exist
  Position: 60 

Please find the below steps we are following:

1. Created a Connect-SQL rule and added the script on Delete tab.

ALTER TABLE pr_table_name
ADD pzPVStream BLOB NULL;
commit;

2.Then using RDB-Delete method in activity, we are executing the scritpt.

we have refered to the following link .

https://community.pega.com/support/support-articles/create-new-record-failed-after-upgrade-conversion-data-tables

We were able to add other columns but facing issue only while trying to add this column.

Thanks,

Bhargav

Data Integration
Moderation Team has archived post
Share this page LinkedIn