From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_dump bug in 7.4 |
Date: | 2003-09-29 02:04:05 |
Message-ID: | 200309290204.h8T245P15767@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I have a fix for this in the patch queue and it will be applied in 24
hours. If you want to try it, it is at:
http://momjian.postgresql.org/cgi-bin/pgpatches
---------------------------------------------------------------------------
Bruno Wolff III wrote:
> If you have a check constraint that tests if a boolean column is not
> false by just using the column name, pg_dump doesn't include parens
> around the check constraint which causes a syntax error when reloading
> the database.
>
> Using the following to create a table:
> create table test (col1 boolean constraint test check (col1));
>
> pg_dump -c produced the following:
> --
> -- PostgreSQL database dump
> --
>
> SET SESSION AUTHORIZATION 'postgres';
>
> SET SESSION AUTHORIZATION 'bruno';
>
> SET search_path = public, pg_catalog;
>
> DROP TABLE public.test;
> SET SESSION AUTHORIZATION 'postgres';
>
> --
> -- TOC entry 3 (OID 2200)
> -- Name: public; Type: ACL; Schema: -; Owner: postgres
> --
>
> REVOKE ALL ON SCHEMA public FROM PUBLIC;
> GRANT ALL ON SCHEMA public TO PUBLIC;
>
>
> SET SESSION AUTHORIZATION 'bruno';
>
> --
> -- TOC entry 4 (OID 605016)
> -- Name: test; Type: TABLE; Schema: public; Owner: bruno
> --
>
> CREATE TABLE test (
> col1 boolean,
> CONSTRAINT test CHECK col1
> );
>
>
> --
> -- Data for TOC entry 5 (OID 605016)
> -- Name: test; Type: TABLE DATA; Schema: public; Owner: bruno
> --
>
> COPY test (col1) FROM stdin;
> \.
>
>
> SET SESSION AUTHORIZATION 'postgres';
>
> --
> -- TOC entry 2 (OID 2200)
> -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
> --
>
> COMMENT ON SCHEMA public IS 'Standard public schema';
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-09-29 02:53:32 | Re: pg_dump bug in 7.4 |
Previous Message | Marc G. Fournier | 2003-09-29 01:58:15 | Re: pgsql-server/src/backend catalog/index.c comma ... |