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

Re: pg_dump bug in 7.4

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2003-09-29 02:53:32
Subject: Re: pg_dump bug in 7.4
Previous:From: Marc G. FournierDate: 2003-09-29 01:58:15
Subject: Re: pgsql-server/src/backend catalog/index.c comma ...

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