Error in pg_dump and pg_dumpall

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
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2004-12-12 20:17:47 Re: concat fails 'sometimes' on empty colums in select
Previous Message Tom Lane 2004-12-12 16:54:28 Re: I am not sure this is a bug but I request help