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))