Thread: pgsql-server/src/bin/pg_dump Tag: REL7_3_STABL ...

pgsql-server/src/bin/pg_dump Tag: REL7_3_STABL ...

From
momjian@svr1.postgresql.org (Bruce Momjian)
Date:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@svr1.postgresql.org    03/06/25 01:09:36

Modified files:
    src/bin/pg_dump: Tag: REL7_3_STABLE pg_dump.c

Log message:
    [ Backpatch to 7.3.X.]

    If they're not, the below causes problems, as the foreign key is added
    after the CHECK.  Cluster depends on the index name, so I thought it
    wise to ensure all names are available, rather than leaving off the
    CONSTRAINT "$n" portion for internally named constraints.

    CREATE TABLE jkey (col integer primary key);
    CREATE TABLE j (col integer REFERENCES jkey);
    ALTER TABLE j ADD CHECK(col > 5);

    This is a problem in 7.3 series as well as -Tip.

    --
    Rod Taylor <rbt@rbt.ca>