CDash:Database: Difference between revisions
From KitwarePublic
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
= Adding/Changing database fields = | |||
= Automatic translation to PGSQL = | |||
The postgres layer in cdash relies on some of the features of the mysqlcompat | The postgres layer in cdash relies on some of the features of the mysqlcompat | ||
package: http://pgfoundry.org/projects/mysqlcompat | package: http://pgfoundry.org/projects/mysqlcompat | ||
Revision as of 22:04, 1 August 2010
Adding/Changing database fields
Automatic translation to PGSQL
The postgres layer in cdash relies on some of the features of the mysqlcompat package: http://pgfoundry.org/projects/mysqlcompat
The following patch to the mysqlcompat package is required to use it with recent versions of PostgreSQL: http://public.kitware.com/Wiki/images/d/d0/Mysqlcompat.txt
(Note that this *is* actually a patch file, but the CDash wiki doesn't allow upload of files ending with ".patch".)
Installation on Ubuntu
apt-get install libsql-translator-perl
Then run the script
CDash/sql/convert.sh
Warning The indexes generated by the script are all the same so you would need to pre-append the table name.
