Bruno Wolff III wrote:
> On Sun, Sep 28, 2003 at 23:16:48 -0400,
> Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> > Christopher Kings-Lynne wrote:
> > > If you are referring to my patch, Bruce - that does not fix it. Mine
> > > only addresses psql.
> > >
> > > I don't think that pg_dump uses pg_get_constraintdef(). It's probably a
> > > side effect of switching from using consrc to conbin.
> >
> >
> > Oh, yea. If forgot the pretty printing only happens in psql.
> >
> > Can someone generate a reproducable failure?
>
> You should be able to get my example to work pretty easily.
>
> Create a table in a convenient database using the following:
> create table test (col1 boolean constraint test check (col1));
>
> Then pg_dump -c the database. As shown in my example below you
> with have a check constraint that is missing parens which will
> cause a syntax error if you try to reload the dump.
OK, it's a must-fix bug for 7.4. Thanks.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073