The following bug has been logged online:
Bug reference: 1418
Logged by: Craig Ruff
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Any
Description:RFC: Challenge/response authentication support
Details:
PAM supports challenge response aut
PostgreSQL 8.0.0
Running "pg_restore -l" to create a list file and then restoring
using "pg_restore -L" fails to restore ACLs. See the "Privileges
where [sic] not restored" thread in pgsql-admin:
http://archives.postgresql.org/pgsql-admin/2005-01/msg00197.php
As I mention in a followup in that
Hi,
pg_dump on 8.0 can't dump index's tablespace information if both table
and its index 's tablespaces are different. For example:
create table a(i int) tablespace ts1;
create index a_idx on a (i) tablespace ts2;
create index a_idx2 on a (i) tablespace pg_default;
Assuming tablespace ts1 ans ts