The following bug has been logged on the website: Bug reference: 17960 Logged by: Sajjad Hassany Pazoky Email address: [email protected] PostgreSQL version: 15.2 Operating system: Windows Description: Hi Dear are two stackoverflow bugs reported an none had an answer: https://stackoverflow.com/questions/64600614/restoring-pg-database-from-dump-fails-due-to-generated-columns https://dba.stackexchange.com/questions/327852/pg-dump-unable-to-produce-a-valid-backup pg_dump does not wite DEFAULT for generated columns. So, it produces error when restoring. The strange part is that when I create the table again, fill it with data and use pg_dump to bacup, it is correct, but the current table in the database producecs wrong backup. I tested this on Postgresql 13, 14, and 15. I'm available if any assistance is needed.
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных
