quotes.install incorrect for PostgreSQL (diff included)

Updating status to show patch available.
@fantux: This is not a patch format that is typically used. Please use "diff -u -p".

See also: http://drupal.org/node/155886

Does this look right?

function quotes_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query('CREATE TABLE {quotes} (
          nid INTEGER NOT NULL,
          vid INTEGER NOT NULL PRIMARY KEY,
          author VARCHAR(255) NOT NULL,
          citation VARCHAR(255),
          promote INTEGER NOT NULL
        ) /*!40100 DEFAULT CHARACTER SET utf8 */');
      db_query('CREATE INDEX {quotes}_nid ON {quotes} (nid)');
      db_query('CREATE INDEX {quotes}_promote ON {quotes} (promote)');

      db_query('CREATE TABLE {quotes_blocks} (
          bid INTEGER NOT NULL PRIMARY KEY,
          name VARCHAR(255) NOT NULL UNIQUE,
          block_type INTEGER NOT NULL,
          nid_filter TEXT NOT NULL,
          rid_filter TEXT NOT NULL,
          uid_filter TEXT NOT NULL,
          tid_filter TEXT NOT NULL,
          cron_interval INTEGER NOT NULL,
          cron_step INTEGER NOT NULL,
          cron_last INTEGER NOT NULL,
          vid INTEGER NOT NULL
        ) /*!40100 DEFAULT CHARACTER SET utf8 */');
      break;
    case 'pgsql':
      db_query('CREATE TABLE {quotes} (
          nid INTEGER NOT NULL,
          vid INTEGER NOT NULL PRIMARY KEY,
          author VARCHAR(255) NOT NULL,
          citation VARCHAR(255),
          promote INTEGER NOT NULL
        ) /*!40100 DEFAULT CHARACTER SET utf8 */');
      db_query('CREATE INDEX {quotes}_nid ON {quotes} (nid)');
      db_query('CREATE INDEX {quotes}_promote ON {quotes} (promote)');
      db_query('CREATE TABLE {quotes_blocks} (
          bid INTEGER NOT NULL PRIMARY KEY,
          name VARCHAR(255) NOT NULL UNIQUE,
          block_type INTEGER NOT NULL,
          nid_filter TEXT NOT NULL,
          rid_filter TEXT NOT NULL,
          uid_filter TEXT NOT NULL,
          tid_filter TEXT NOT NULL,
          cron_interval INTEGER NOT NULL,
          cron_step INTEGER NOT NULL,
          cron_last INTEGER NOT NULL,
          vid INTEGER NOT NULL
        ) /*!40100 DEFAULT CHARACTER SET utf8 */');
  }
}

Fix committed.