[PATCH]: PostgreSQL support
GeoffGlasson - February 8, 2007 - 08:34
| Project: | Bibliography Module |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I have attached a patch to the 4.7 version of the module to allow it to run with PostgreSQL. I have done basic testing with PostgreSQL and it seems to work as expected. I don't have a running installation of mySQL so I cannot confirm that I changes work against that DB.
You will note that the code to insert the various data items into the database is not particularly good. I am not proficient in PHP and simply cut and paste the code. I'm sure that there is a better way to do it.
| Attachment | Size |
|---|---|
| biblio.install.patch | 26.6 KB |
#1
Thanks for that, I'll take a look at it and see if I can incorporate it into the release version.
#2
I came across a problem with the PostgreSQL support on my main website running 4.7.4 whereas my test system is running 4.7.6. The problem has to do with the mechanism for inserting new types of publications. The generated SQL generated is not compatible with PostgreSQL. I haven't had a chance to check it out on my test system yet, but will do so this week and post additional information and hopefully a patch as well.