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.

CommentFileSizeAuthor
userprotect.install.patch2.21 KBjaydub

Comments

hunmonk’s picture

Status: Postponed (maintainer needs more info) » Needs work

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.

hunmonk’s picture

Version: 4.7.x-1.x-dev » 7.x-1.x-dev
Status: Needs work » Fixed

i fixed up the patch and applied to all branches -- thanks!

Anonymous’s picture

Status: Fixed » Closed (fixed)