Re: Problemas con pgdump

Salida del pg_dump que me has pedido:

--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: suggeriments; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE suggeriments (
idsuggeriment serial NOT NULL,
idprofessional integer NOT NULL,
contingut text NOT NULL
);

ALTER TABLE public.suggeriments OWNER TO postgres;

--
-- Name: suggeriment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY suggeriments
ADD CONSTRAINT suggeriment_pkey PRIMARY KEY (idsuggeriment);

ALTER INDEX public.suggeriment_pkey OWNER TO postgres;

--
-- Name: suggeriments_professionals_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY suggeriments
ADD CONSTRAINT suggeriments_professionals_fkey FOREIGN KEY (idprofessional) REFERENCES professionals(idprofessional) ON UPDATE CASCADE ON DELETE RESTRICT;

--
-- Name: suggeriments; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE suggeriments FROM PUBLIC;
REVOKE ALL ON TABLE suggeriments FROM postgres;
GRANT ALL ON TABLE suggeriments TO postgres;
GRANT ALL ON TABLE suggeriments TO web;

--
-- Name: suggeriment_idsuggeriment_seq; Type: ACL; Schema: public; Owner: postgres
--

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;

--
-- PostgreSQL database dump complete
--

---- Alvaro Herrera <alvherre(at)commandprompt(dot)com> escribió:
> Xavier Vidal escribió:
> > Saludos
> >
> > Ante todo, debo decir que me adelanté y afirmé que las secuencias estaban
> > mal escritas. (disculpas por el error)
> >
> > Pues no, los nombres están correctos, ya que consultando "relname" en la
> > tabla "pg_class" aparecen así.
> >
> > Lo que no entiendo es porqué da error, si los nombres están bien, entonces
> > qué falla?
>
> Tengo la sospecha que alguna vez hiciste un "alter table suggeriment
> rename to suggeriments" o algo por el estilo.
>
> Dime, que pasa si haces
>
> pg_dump -s -t suggeriments
>
> ? Muestra la salida completa por favor.
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 4: No hagas 'kill -9' a postmaster