I haven't had much time to look further but wanted to report that errors received after upgrading and running update.php. 

  * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "Array" LINE 1: ALTER TABLE mysite ADD integer Array ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: ALTER TABLE mysite ADD integer Array in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "integer" of relation "mysite" does not exist LINE 1: UPDATE mysite SET integer = uid_old ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: UPDATE mysite SET integer = uid_old in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: index "mysite_uid_idx" does not exist in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: DROP INDEX mysite_uid_idx in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid" does not exist in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: CREATE INDEX mysite_uid_idx ON mysite (uid) in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "PRIMARY" LINE 1: ALTER TABLE mysite ADD CONSTRAINT PRIMARY KEY (uid) ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: ALTER TABLE mysite ADD CONSTRAINT PRIMARY KEY (uid) in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "PRIMARY" LINE 1: ALTER TABLE mysite_data ADD CONSTRAINT PRIMARY KEY (mid) ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: ALTER TABLE mysite_data ADD CONSTRAINT PRIMARY KEY (mid) in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "PRIMARY" LINE 1: ALTER TABLE mysite_content ADD CONSTRAINT PRIMARY KEY (myid) ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: ALTER TABLE mysite_content ADD CONSTRAINT PRIMARY KEY (myid) in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.

And the confirmation information from update.php ...

mysite module
Update #8

    * ALTER TABLE {mysite_data} ADD page int
    * ALTER TABLE {mysite_data} ALTER page SET default 0
    * UPDATE {mysite_data} SET page = 0
    * ALTER TABLE {mysite_data} ALTER page SET NOT NULL
    * CREATE INDEX {mysite_data}_page_idx ON {mysite_data} (page)

Update #9

    * CREATE TABLE {mysite_page} ( page integer NOT NULL default '0', uid integer NOT NULL default '0', created integer NOT NULL default '0', updated integer, status integer NOT NULL default '0', title varchar(80) NOT NULL default '', layout varchar(40) NOT NULL default 'default', style varchar(40) NOT NULL default 'default', format varchar(40) NOT NULL default 'default', theme varchar(40) NULL, UNIQUE (page, uid) )
    * CREATE INDEX {mysite_page}_page_idx ON {mysite_page} (page)
    * CREATE INDEX {mysite_page}_uid_idx ON {mysite_page} (uid)

Update #10

    * ALTER TABLE {mysite} RENAME uid TO uid_old
    * Failed: ALTER TABLE {mysite} ADD integer Array
    * Failed: UPDATE {mysite} SET integer = uid_old
    * ALTER TABLE {mysite} DROP uid_old
    * Failed: DROP INDEX {mysite}_uid_idx
    * Failed: CREATE INDEX {mysite}_uid_idx ON {mysite} (uid)
    * Failed: ALTER TABLE {mysite} ADD CONSTRAINT PRIMARY KEY (uid)
    * Failed: ALTER TABLE {mysite_data} ADD CONSTRAINT PRIMARY KEY (mid)
    * Failed: ALTER TABLE {mysite_content} ADD CONSTRAINT PRIMARY KEY (myid)

Update #11

    * No queries

Let me know if you'd like me to try something or take this further somehow. My technical guy is out today, otherwise he would have given some of these errors as shot.

Comments

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Active » Needs review

These are all errors stemming from my misreading of the postgreSQL docs.

Try replacing update_10 with:

/**
 * Update to 5.x.3 -- corrections to pgsql
 */
function mysite_update_10() {
  $ret = array();
  if ($GLOBALS['db_type'] == 'pgsql') {
    db_change_column($ret, 'mysite', 'uid', 'uid', 'integer', array('not null' => TRUE, 'default' => 0));
    // Reindex the column.
    $ret[] = update_sql("CREATE INDEX {mysite}_uid_idx ON {mysite} (uid)");
    $ret[] = update_sql("ALTER TABLE {mysite} ADD PRIMARY KEY (uid)");
    $ret[] = update_sql("ALTER TABLE {mysite_data} ADD PRIMARY KEY (mid)");    
    $ret[] = update_sql("ALTER TABLE {mysite_content} ADD PRIMARY KEY (myid)");
  }
  return $ret;
}

And then try it again.

WISEOZ’s picture

WISEOZ commented

I made this change and ran update.php again and received no errors. I'll let you know under a separate ticket if I see anything else. Thanks!

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

Well, you should also check your pgSQL tables to see if the relevant indexes and keys were created.

This update is specifically to try to improve performance on pgSQL, so that older MySite installs mirror the new database schema.

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Title: Install Errors Upon Upgrading from 2.15 to 3.0beta3 » pgSQL errors upgrading from 2.15 to 3.0beta3
Status: Needs review » Reviewed & tested by the community
agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented
Status: Reviewed & tested by the community » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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