phppgadminubuntu-22.04postgresql-14

Cannot edit or delete data or rows within phppgadmin


When I try to edit data in phppgadmin, no matter which table or row, I always got following notification 'No unique identifier for this row.' and nothing is changed/saved.
The user I'm logged in has full privileges on the database and all tables in database have primary keys.
I'm using phppgadmin for many years and I've never had such a problem before. I should mention, this is a fresh installation of Ubuntu.

Does anyone has a clue what happening here and how to solve this issue? Thanks

EDIT
Even downgrading postgresql to version 13 didn't help.


Solution

  • It's reported as a problem with PHP 8.1.x. You can install phpPgAdmin 7.14.2-mod from https://github.com/ReimuHakurei/phpPgAdmin which has a patch to fix this problem.