Yii1, postgres version supported

Hi All,

I have installed a Yii1 app with a pg12 database, but does not work. When creating AR objects, we have an error when reading metadata tables. I pasted the query below, the problem is that the column d.adsrc does not exist in the table pg_attdef.

The question is, any ideas which version of pg can I use for a Yii1 app ? Can’t find that on the docs.

Many thanks

SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))

Same problem.

Solved with pathcing [framework/db/schema/pgsql/CPgsqlSchema.php] like in this commit on github: https://github.com/LimeSurvey/LimeSurvey/pull/1346/commits/0a22c3861885ebabb8c4a241e54809ff75f8473c