Some patches for getting this working with PostgreSQL.

To apply the patch, cd into tvi then patch -p0 -i tvi-pgsql.patch

Notes to developer:

Backticks are unnecessary in MySQL. INSERT queries very well work without them. But backticks create problems for PostgreSQL users. It is n't recognized in pgsql.

Also never use double quotes in where statements because double quotes in PostgreSQL is recognized as column names (as per SQL Standards). You must use single quotes to compare strings. MySQL isn't standards complaint so it will not give errors on such small things. But PostgreSQL strictly follows the standards.

CommentFileSizeAuthor
tvi-pgsql.patch1.47 KBnileshgr

Comments

derekwebb1’s picture

derekwebb1 commented

Thanks Nilesh!

We'll add that to the next release which should be pretty soon.

Cheers, Derek

derekwebb1’s picture

derekwebb1 commented

I think the dev release should fix this. Please review the dev branch. Thank you for your help!

duaelfr’s picture

duaelfr
he/him
Primary language French
Location Montpellier, France
commented
Status: Needs review » Closed (fixed)