BUG #17960: pg_dump does not backup generated columns correctly.
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #17960: pg_dump does not backup generated columns correctly. |
| Дата | |
| Msg-id | 17960-1a424b3d6792d769@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #17960: pg_dump does not backup generated columns correctly.
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17960 Logged by: Sajjad Hassany Pazoky Email address: ijustloveit13@gmail.com 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 по дате отправления: