BUG #7842: pg_dump scripts view to table
| От | lopuszanski@oleofarm.com |
|---|---|
| Тема | BUG #7842: pg_dump scripts view to table |
| Дата | |
| Msg-id | E1U0veF-0007cU-7z@wrigleys.postgresql.org обсуждение |
| Ответы |
Re: BUG #7842: pg_dump scripts view to table
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 7842 Logged by: Maciej =C5=81opusza=C5=84ski Email address: lopuszanski@oleofarm.com PostgreSQL version: 9.1.7 Operating system: ubuntu 12.04 Description: = hello, 1. after using pg_dump to dump WHOLE database to file, 1 of views 'turned' into a table. so there is no 'create or replace VIEW XXXX .......' with definition, but instead: its scripted as 'create TABLE XXXX......' and definition.(in file that pg_dump created) 2. but after using pg_dump to dump only this 1 problematic 'view' (with -t option) it stores it correcly as 'create or replace VIEW XXXX .......' it looks like pg_dump has problem with dependancies of this view..... what other information I should supply to solve this mystery of pg_dump?
В списке pgsql-bugs по дате отправления: