Обсуждение: Error in pg_dump and pg_dumpall

Name        :    Slawomir Sudnik
Email    address:    slawek@icpnet.pl

Operating System      : Linux Fedora / Windows XP

PostgreSQL version     :   8.0 rc1

Descrtiption:  Error in pg_dump and pg_dumpall

Details:

I made from database dump and received:

(...)

COMMENT ON CONSTRAINT b_c_check ON b IS 'constraint - b_c_check';

SET default_tablespace = '';

SET default_with_oids = true;

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

CREATE TABLE b (
    c text NOT NULL,
    CONSTRAINT b_c_check CHECK ((length(c) > 1))
);

ALTER TABLE public.b OWNER TO postgres;

--
-- Name: TABLE b; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE b IS 'Table - b';

--
                                                     --
-- Name: COLUMN b.c; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN b.c IS 'Column - c';

(...)

The comment on constraint of type the CHECK is before creation of mother
table.


Greets,
Slawomir Sudnik

slawek@poczta.icpnet.pl writes:
> The comment on constraint of type the CHECK is before creation of mother
> table.

Yeah, I reproduced this here.  The ordering of comments isn't completely
right --- if we fold the constraint into the mother table then the
dependency that should make the ordering go the right way isn't
preserved.  Thanks for the report.

            regards, tom lane