Symptom

When you create a DataWindow or call function SyntaxFromSQL, the PostgreSQL server log shows the following error.

2022-07-03 19:00:30.324 PDT [7484] ERROR:  column p.adsrc does not exist at character 26


Environment 

PowerBuilder 2017/2019/2021


Cause

Since PostgreSQL 12, column adsrc was removed.

https://pgpedia.info/p/pg_attrdef.html


Resolution

You need to use function pg_get_expr to get the default value instead of using the adsrc column.

Please find the following line in pbodb.ini:

SelectDefault='SELECT a.attname as name,p.adsrc FROM pg_catalog.pg_class as c Left JOIN pg_catalog.pg_attrdef as p ON c.oid = p.adrelid LEFT JOIN pg_catalog.pg_attribute as a ON p.adnum = a.attnum INNER JOIN pg_catalog.pg_type ON pg_type.oid = a.atttypid WHERE c.relname = ''&TableName'' AND a.attrelid = c.oid AND a.attnum>0'


And modify it as follows:

SelectDefault='SELECT a.attname as name, pg_catalog.pg_get_expr(p.adbin, p.adrelid) as adsrc FROM pg_catalog.pg_class as c Left JOIN pg_catalog.pg_attrdef as p ON c.oid = p.adrelid LEFT JOIN pg_catalog.pg_attribute as a ON p.adnum = a.attnum INNER JOIN pg_catalog.pg_type ON pg_type.oid = a.atttypid WHERE c.relname = ''&TableName'' AND a.attrelid = c.oid AND a.attnum>0'


 

4
0