From: | lopuszanski(at)oleofarm(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7842: pg_dump scripts view to table |
Date: | 2013-01-31 15:01:55 |
Message-ID: | E1U0veF-0007cU-7z@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7842
Logged by: Maciej Łopuszański
Email address: lopuszanski(at)oleofarm(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Toby Murray | 2013-01-31 17:17:52 | Violation of primary key constraint |
Previous Message | biernatj | 2013-01-31 09:49:29 | BUG #7841: Multithreading in libpq is not working |