#719 Unable to select the table (ERROR: column d.adsrc does not exist)

[dubovitsky oleg]

Hello, i have an error. I use postgres, node js(sequelize) and via SQL request i can select my tables in db. Datas record in db and server works without problem. Help me, please.
'Unable to select the table'

[Nikolay Kolev]

This is postgresql 12 bug ...

[mike]

This is not a bug. See my comment.

[mike]

It's not a postgresql bug - it's been removed in V 12.

In fact, the release notes for V12 say:

Remove obsolete pg_attrdef.adsrc column (Peter Eisentraut)

Source: https://www.postgresql.org/docs/release/12.0/

It exists up to V11:
https://www.postgresql.org/docs/11/catalog-pg-attrdef.html

For V12:
https://www.postgresql.org/docs/12/catalog-pg-attrdef.html

From old the Postgres docs:

"The adsrc field is historical, and is best not used, because it does not track outside changes that might affect the representation of the default value. Reverse-compiling the adbin field (with pg_get_expr for example) is a better way to display the default value."

[mike]

I fixed this on the github repo, not sure how to ad a PR here: https://github.com/vrana/adminer/pull/367

[dubovitsky oleg]

I'm sorry, but there is still error

[Jakub Vrána]

Merged, thanks.