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?