Here is a basic dump of the tables, I think I've managed to create all the proper columns with proper types and default values, check the ejournal_journals table, specifically the enabled and issue_format types.

See attached. I tried putting that into ejournal.install with the proper syntax for db_query("CREATE... but for some reason when installing the queries won't execute, so I've left that part out for now.

CommentFileSizeAuthor
ejournal-psql-tables.txt2.28 KBjamonation

Comments

jamonation’s picture

jamonation commented
Status: Postponed (maintainer needs more info) » Needs review

Note that for some reason in that dump "timestamp" and "year" are in double quotes, those should read 'timestamp' and 'year'.

romca’s picture

romca commented

Hi jamonation,
thanks again for your work. When I wrote to you last time I did not realize I should review it - there is the ejournal_article_log -> ejournal_log change, but i can fix that easily, so I think no other issues in the scheme creation. My question is: is the module working for you? With the postgresql database, all the queries?
Cheers

romca’s picture

romca commented
Status: Needs review » Postponed
romca’s picture

romca commented
Status: Postponed » Closed (fixed)

the installation is not an issue because of the new Drupal db layer - but the queries may not work (not tested with postgresql)