BUG #7842: pg_dump scripts view to table

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?

Responses

Browse pgsql-bugs by date

  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