Re: Problemas con pgdump

Xavier Vidal escribió:

> REVOKE ALL ON TABLE suggeriment_idsuggeriment_seq FROM PUBLIC;
> REVOKE ALL ON TABLE suggeriment_idsuggeriment_seq FROM postgres;
> GRANT ALL ON TABLE suggeriment_idsuggeriment_seq TO postgres;
> GRANT ALL ON TABLE suggeriment_idsuggeriment_seq TO web;

[falta una s]

Hmm, muy raro. Haz esto:

select relname from pg_class where relname like 'sugger%' and relkind = 's';
set enable_indexscan to off;
select relname from pg_class where relname like 'sugger%' and relkind = 's';

> REVOKE ALL ON TABLE "llibre-apartats_idapartat_seq" FROM PUBLIC;
> REVOKE ALL ON TABLE "llibre-apartats_idapartat_seq" FROM postgres;
> GRANT ALL ON TABLE "llibre-apartats_idapartat_seq" TO postgres;
> GRANT ALL ON TABLE "llibre-apartats_idapartat_seq" TO web;

[un _ fue cambiado a -]

select relname from pg_class where relname like 'llibre%' and relkind = 's';
set enable_indexscan to off;
select relname from pg_class where relname like 'llibre%' and relkind = 's';

Cada cuanto tiempo haces vacuum de pg_class?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support