postgres 8.1 on latest drupal dev: latest cck fresh installation fails when trying to create the tables node_story, node_page & node_forum

query: CREATE TABLE node_story ( vid integer unsigned NOT NULL default '0', nid integer unsigned NOT NULL default '0', PRIMARY KEY (vid) ) in D:\WEBSITE\drupal-cvs\includes\database.pgsql.inc on line 144.
pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" at character 49 in D:\WEBSITE\drupal-cvs\includes\database.pgsql.inc on line 125.
query: CREATE TABLE node_page ( vid integer unsigned NOT NULL default '0', nid integer unsigned NOT NULL default '0', PRIMARY KEY (vid) ) in D:\WEBSITE\drupal-cvs\includes\database.pgsql.inc on line 144.
pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" at character 48 in D:\WEBSITE\drupal-cvs\includes\database.pgsql.inc on line 125.
query: CREATE TABLE node_forum ( vid integer unsigned NOT NULL default '0', nid integer unsigned NOT NULL default '0', PRIMARY KEY (vid) ) in D:\WEBSITE\drupal-cvs\includes\database.pgsql.inc on line 144.
pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" at character 49 in D:\WEBSITE\drupal-cvs\includes\database.pgsql.inc on line 125.

Comments

karens’s picture

karens commented

I think this would be fixed with http://drupal.org/node/100546. Can you tell if that is the problem? I have no postgres installation that I can test on.

Pieter Janssens’s picture

Pieter Janssens commented

yes! (i missed http://drupal.org/node/100546, didn't search for postgresql, but only for postgres).
the module content_crud.inc also needs to be patched.
i'm not sure though if this patch breaks compatibility with postgres version 7.x
also there appears to be some mapping going on between mysql and pgsql field types, and cck contains an error message for a mapping that is missing. is this because it is simply not possible to map every mysql database field type, or did nobody got around to fixing this?

karens’s picture

karens commented
Status: Active » Closed (duplicate)

There are several issues opened about postgres compatibility. I'm going to mark all but one as a duplicate and try to get a working patch that can be tested by those who use postgres. I see the following issues:

http://drupal.org/node/109060, http://drupal.org/node/100546, http://drupal.org/node/106892.

I'm going to mark all but http://drupal.org/node/100546 as duplicates, and work on the patch there, since it seems to be the most complete of the proposed fixes.