PostgreSQL support
dmurray - July 25, 2009 - 03:15
| Project: | Storage API |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Drupal 6.13
Mimedetect 6.x-1.2
Storage API 6.x-1.x-dev
When enabling Filesystem / Drupal these errors are shown:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "SET" LINE 3: SET service_id = 'fs_drupal' ^ in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO storage_service SET service_id = 'fs_drupal' in /var/vwww/video.eagleseye.ca/html/sites/all/modules/storage_api/storage_api.module on line 401.Filesystem / Drupal shows as active but when tring to create a container this error is received:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "SET" LINE 3: SET name = 'Local storage', ^ in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO storage_container SET name = 'Local storage', service_id = 'fs_drupal', serving = 0, settings = 'a:1:{s:4:"path";s:19:"sites/default/files";}' in /var/vwww/video.eagleseye.ca/html/sites/all/modules/storage_api/containers.admin.inc on line 235.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "storage_container_container_id_seq" is not yet defined in this session in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT CURRVAL('storage_container_container_id_seq') in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 232.Any help would be appreciated.
#1
PostgreSQL isn't supported yet - only MySQL.