PostgreSQL support
jaydub - January 10, 2007 - 10:42
| Project: | User Protect |
| Version: | 7.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
See attached patch for prelim PostgreSQL support. Defaults seem reasonable. The MySQL table def includes a 'UNIQUE KEY' which has no directory corollary in PostgreSQL. Normally a 'KEY' alone in a table def is an alias for an INDEX. If the 'KEY' portion of the 'UNIQUE KEY' in MySQL is for an index, then the PostgreSQL def will also need a CREATE INDEX call.
| Attachment | Size |
|---|---|
| userprotect.install.patch | 2.21 KB |
#1
afaik KEY is a synonym for pgSQL's INDEX, so go ahead and add the index query to the patch, and i'll review further.
#2
i fixed up the patch and applied to all branches -- thanks!
#3