Hello,
I found a problem when installing this module on a server using Postgresql 8.2.6.

It was solved modifying the file 'custom_breadcrumbs.install'.

1. Remove {}
2. correct typo: nid >=0 to bid >=0

CREATE TABLE custom_breadcrumb (
bid serial CHECK (bid >= 0),
titles varchar(255) NOT NULL default '',
paths varchar(255) NOT NULL default '',
node_type varchar(64) default ''
)

Comments

kotoponus’s picture

kotoponus commented

If you get the following errors:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "nid" does not exist in /var/www/drupal5/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE TABLE custom_breadcrumb ( bid serial CHECK (nid >= 0), titles varchar(255) NOT NULL default '', paths varchar(255) NOT NULL default '', node_type varchar(64) default '' ) in /var/www/drupal5/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "custom_breadcrumb" does not exist in /var/www/drupal5/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE INDEX custom_breadcrumb_bid_idx ON custom_breadcrumb (bid) in /var/www/drupal5/includes/database.pgsql.inc on line 144.

Don't forget to run this after above query:

CREATE INDEX custom_breadcrumb_bid_idx ON custom_breadcrumb (bid);

MGN’s picture

MGN commented
Status: Active » Fixed

Thanks. This was fixed in duplicate issue #346113: PgSql Support and committed to 5.x-1.x-dev.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.