Posted by jaydub on January 10, 2007 at 10:42am
Jump to:
| Project: | User protect |
| Version: | 7.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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 |
Comments
#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