The following bug has been logged on the website: Bug reference: 7842 Logged by: Maciej Łopuszański Email address: lopuszan...@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? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
