BUG #6640: pg_dump does not always dump data of tables marked as editable in extension

From: lr(at)pcorp(dot)us
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension
Date: 2012-05-15 12:27:10
Message-ID: E1SUGqM-0006yE-Fn@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: 6640
Logged by: Regina Obe
Email address: lr(at)pcorp(dot)us
PostgreSQL version: 9.1.3
Operating system: Any
Description:

This seems to be only an issue if a user individually chooses to backup a
table marked as editable in an extension, but works fine if full backup is
chosen.

The particular extension in question here is PostGIS.

Please refer to:
http://trac.osgeo.org/postgis/ticket/1815

for details.
In short -- if I do a full backup of a database, a table marked as editable
gets its data backed up as expected, but if I try to backup a schema the
table is in or the table itself, pg_dump does not dump anything.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2012-05-15 18:36:30 Re: [BUGS] BUG #6639: Manual uses boldface where it says italic, and monospace where it says boldface
Previous Message Martin Pitt 2012-05-15 12:25:00 9.2beta1 regression: pg_restore --data-only does not set sequence values any more