Print Topic - Archive
E-Blah Community / General E-Blah SQL / PostgreSQL
Posted by: vol7ron, April 14, 2008, 5:01pm
Is anyone interested in getting this to work with PostgreSQL? I've modified the install files so that it sets up the tables/sequences/indexes, I feel it's on the brink of installing correctly.
There's some sort of connection issue that is a problem when running Blah.pl after install that I'm looking into tomorrow. I'm doing this so that I can use it for work, but would it benefit anyone else?
Posted by: Justin, April 15, 2008, 1:22am; Reply: 1
If you fix it to work well, I'll add it to the next release.
Posted by: vol7ron, April 15, 2008, 7:30am; Reply: 2
Definitely working on it. I found a nice little MySQL -> PostgreSQL script from pgFoundry.org It wasn't the best converter but handled a LOT of the work.
As I said the Tables/Sequences/Indexes were created correctly, which was half the install. The point I'm at right now is figuring out an error on the final install page, which is blank. There's no line number, no error code, just an error box. Then there's a connection problem when continuing on. I feel these are related and should be an easy fix, once found. The problem is probably with the pg.pm file I created (copied from mysql.pm).
I hope I have the time to finish looking at this because it would be very useful at work. We're using tWiki at the moment (a wiki built with perl for linux), which is great for documentation and procedures, but a discussion board would be nice for question & answers as well as a collaborative place for project ideas.
Posted by: vol7ron, April 15, 2008, 4:27pm; Reply: 3
I almost have it working for me. --- It installs fine and the tables populate, but now there's a problem logging in and registering users.
The last problem was in the INSERT INTO and UPDATE query syntax.
I was not as familiar with PostgreSQL syntax differences, especially when jumping from SAS to Access to SQL Server to Oracle to MySQL to DB2 and now back to this. But this was good learning experience.
I'll try to figure out what's up with the log in, but if you have any suggestions on how it works, it might save me time instead of diving into the code.
------------------
Edit:
I might have fixed that, now the problem is that whenever I click a new page, the active user list is duplicated. It's I click on a category I'm listed in active users twice.
Argh these problems never cease to stop and to think it'd be a quick fix because most of the code is the same.
------------------
Nevermind to this too... just another problem with the WHERE syntax as part of the DELETE query. I think we're almost there. I'll post again when there's an issue I would prefer some help to solve
Print page generated: September 5, 2008, 8:35pm