summaryrefslogtreecommitdiff
path: root/contrib/adddepend/README.adddepend
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/adddepend/README.adddepend')
-rw-r--r--contrib/adddepend/README.adddepend45
1 files changed, 0 insertions, 45 deletions
diff --git a/contrib/adddepend/README.adddepend b/contrib/adddepend/README.adddepend
deleted file mode 100644
index d00689f2e5..0000000000
--- a/contrib/adddepend/README.adddepend
+++ /dev/null
@@ -1,45 +0,0 @@
-
- Dependency Additions For PostgreSQL 7.3 Upgrades
-
-In PostgreSQL releases prior to 7.3, certain database objects didn't
-have proper dependencies. For example:
-
-1) When you created a table with a SERIAL column, there was no linkage
-to its underlying sequence. If you dropped the table with the SERIAL
-column, the sequence was not automatically dropped.
-
-2) When you created a foreign key, it created three triggers. If you
-wanted to drop the foreign key, you had to drop the three triggers
-individually.
-
-3) When you created a column with constraint UNIQUE, a unique index was
-created but there was no indication that the index was created as a
-UNIQUE column constraint.
-
-Fortunately, PostgreSQL 7.3 and later now tracks such dependencies
-and handles these cases. Unfortunately, PostgreSQL dumps from prior
-releases don't contain such dependency information.
-
-This script operates on >= 7.3 databases and adds dependency information
-for the objects listed above. It prompts the user on whether to create
-a linkage for each object. You can use the -Y option to prevent such
-prompting and have it generate all possible linkages.
-
-This program requires the Pg:DBD Perl interface.
-
-Usage:
-
- adddepend [options] [dbname [username]]
-
-Options:
- -d <dbname> Specify database name to connect to (default: postgres)
- -h <host> Specify database server host (default: localhost)
- -p <port> Specify database server port (default: 5432)
- -u <username> Specify database username (default: postgres)
- --password=<pw> Specify database password (default: blank)
-
- -Y The script normally asks whether the user wishes to apply
- the conversion for each item found. This forces YES to all
- questions.
-
-Rod Taylor <pg@rbt.ca>