From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql-server/src/bin/pg_dump pg_dump.c |
Date: | 2003-06-25 04:08:19 |
Message-ID: | 20030625040819.DF34430FB54@svr1.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)svr1(dot)postgresql(dot)org 03/06/25 01:08:19
Modified files:
src/bin/pg_dump: pg_dump.c
Log message:
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(at)rbt(dot)ca>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-06-25 04:09:36 | pgsql-server/src/bin/pg_dump Tag: REL7_3_STABL ... |
Previous Message | Bruce Momjian | 2003-06-25 03:56:31 | pgsql-server/src backend/utils/adt/ruleutils.c ... |