Feature #6898
PostgreSQL schema improvements
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:
0%
billable:
No
vendor_id:
GCD
version:
Related issues
History
#1 Updated by Greg Shah over 1 year ago
- Related to Support #4058: consider denormalizing tables as the default approach added
#2 Updated by Greg Shah over 1 year ago
We have multiple requests for changes to the default approach to some PostgreSQL schema. We have a small window right now in which we can tolerate some improvements to the schema. The obvious changes:
- use of a native case-insensitive data type (
citext
?) forcharacter
instead of usingTEXT
and accessing it usingUPPER(RTRIM())
(see also #2949) - doing a non-crappy job of extent column support (see #4060, #4058 and #6418)
Eric: Am I missing anything here?
#3 Updated by Greg Shah over 1 year ago
- Related to deleted (Support #4058: consider denormalizing tables as the default approach)
#4 Updated by Greg Shah over 1 year ago
- Related to Feature #6418: represent extent fields as arrays added
#5 Updated by Greg Shah over 1 year ago
- Related to Support #4058: consider denormalizing tables as the default approach added