I built the latest ovirt-engine from GIT and attempted to upgrade. Version that I attempting to upgrade was built Monday from master (commit: a665ec3af7b2dd04e80007b1c062868d3e049fce).

Below is the what was logged by engine-upgrade:
2012-11-09 14:15:54::DEBUG::engine-upgrade::425::root:: DB Update started
2012-11-09 14:15:54::DEBUG::common_utils::390::root:: Executing command --> '/usr/share/ovirt-engine/dbscripts/upgrade.sh -s localhost -p 5432 -u engine -d engine_2012_11_09_14_12_52'
2012-11-09 14:15:58::DEBUG::common_utils::428::root:: output = upgrade script detected a change in Config, View or Stored Procedure...

2012-11-09 14:15:58::DEBUG::common_utils::429::root:: stderr = psql:create_functions.sql:666: ERROR:  must be owner of function uuid_generate_v1

2012-11-09 14:15:58::DEBUG::common_utils::430::root:: retcode = 3
2012-11-09 14:15:58::ERROR::engine-upgrade::1072::root:: Traceback (most recent call last):
  File "/usr/bin/engine-upgrade", line 1059, in main
    runFunc([db.update], MSG_INFO_DB_UPDATE)
  File "/usr/bin/engine-upgrade", line 607, in runFunc
    func()
  File "/usr/bin/engine-upgrade", line 442, in update
    output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=MSG_ERROR_UPDATE_DB)
  File "/usr/share/ovirt-engine/scripts/common_utils.py", line 433, in execCmd
    raise Exception(msg)
Exception: Error: Database update failed

 - DHC