Skip site navigation (1) Skip section navigation (2)

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. (view raw, whole thread or download thread mbox)
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


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:

    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

Slawomir Sudnik


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group