OpenACS docs are written by the named authors, but may be edited
by OpenACS documentation staff.
The Big Picture
@@ -28,7 +28,7 @@
Truncate the column name until it fits.
If the constraint name is still too long, you should consider rewriting your
entire data model :)
-
Notes:
If you have to abbreviate the table name for one of the constraints, abbreviate it for all the constraints
If you are defining a multi column constraint, try to truncate the two column names evenly
Example
+
Notes:
If you have to abbreviate the table name for one of the constraints, abbreviate it for all the constraints
If you are defining a multi column constraint, try to truncate the two column names evenly
Example
create table example_topics (
topic_id integer
constraint example_topics_topic_id_pk
@@ -82,4 +82,4 @@
debugging (e.g. the error will say something like
"Cannot insert null value into column"), we recommend naming not null
constraints to be consistent in our naming of all constraints.
-