diff options
| author | Yorhel <git@yorhel.nl> | 2015-10-11 14:03:50 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2015-10-12 19:35:18 +0200 |
| commit | 1a6dd0160a75bc83390912dfb2635cd5664ce9ee (patch) | |
| tree | a8ed2161296205b2f9c8cbee27b11554e7c60a48 /util/sql/func.sql | |
| parent | 15382265b39f045fc5f20e9e676b24941da6bd63 (diff) | |
SQL: Split constraints/indices/triggers in new file + use idempotent SQL
Turning the foreign key references into idempotent statements required
adding the name for each reference in the query. I used the names of the
production database, but since the names are autogenerated at creation
time, it's possible that they have other names if the database has been
created slightly differently.
Using explicit names for everything and having idempotent SQL statements
is rather useful when making nontrivial modifications to the database
schema. Which is something I consider doing.
Diffstat (limited to 'util/sql/func.sql')
| -rw-r--r-- | util/sql/func.sql | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 6f675479..51711f77 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -1,4 +1,3 @@ - -- A small note on the function naming scheme: -- edit_* -> revision insertion abstraction functions -- *_notify -> functions issuing a PgSQL NOTIFY statement |