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 .
We were able to add other columns but facing issue only while trying to add this column.
Thanks,
Bhargav
Accepted Solution
PEG
GB
They syntax may depend on the underlying database type.
I see you have a commit after your alter statement. Is this for a PostgreSQL database by any chance?
If so, in case this helps, when I examine by pegadata.pc_work in pgadmin the syntax that I see is: -
ALTER TABLE pegadata.pc_work ADD COLUMN pzpvstream bytea;
Evoke Technologies
IN
Hi Bhavya,
Thank you for the response.
We have been mentioning the datatype as BLOB to add pzpvStream which is why we are facing this issue.
As Laurence here suggested, we have added the type as "bytea" and it worked.
Thanks,
Bhargav
Accepted Solution
PEG
GB
They syntax may depend on the underlying database type.
I see you have a commit after your alter statement. Is this for a PostgreSQL database by any chance?
If so, in case this helps, when I examine by pegadata.pc_work in pgadmin the syntax that I see is: -
ALTER TABLE pegadata.pc_work ADD COLUMN pzpvstream bytea;
Evoke Technologies
IN
Hi Laurence,
Thank you for the response.
The solution has worked. It has successfully added the column.
Regards,
Bhargav
