Lists: | pgsql-bugs |
---|
From: | slawek(at)poczta(dot)icpnet(dot)pl |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Error in pg_dump and pg_dumpall |
Date: | 2004-12-12 17:03:54 |
Message-ID: | 63805.83.27.231.163.1102871034.squirrel@83.27.231.163 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Name : Slawomir Sudnik
Email address: slawek(at)icpnet(dot)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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | slawek(at)poczta(dot)icpnet(dot)pl |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Error in pg_dump and pg_dumpall |
Date: | 2004-12-14 02:23:58 |
Message-ID: | 8031.1102991038@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
slawek(at)poczta(dot)icpnet(dot)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