BEGIN Timing is on. CREATE FUNCTION Time: 3.080 ms omero_assert_db_version ------------------------- (1 row) Time: 4.917 ms DROP FUNCTION Time: 0.305 ms INSERT 0 1 Time: 2.102 ms CREATE FUNCTION Time: 0.980 ms UPDATE 5 Time: 2.641 ms UPDATE 0 Time: 0.964 ms UPDATE 0 Time: 0.368 ms UPDATE 0 Time: 0.793 ms UPDATE 0 Time: 0.781 ms DELETE 0 Time: 3.007 ms DELETE 0 Time: 3.016 ms DELETE 0 Time: 1.871 ms CREATE FUNCTION Time: 0.459 ms CREATE FUNCTION Time: 0.624 ms CREATE FUNCTION Time: 0.875 ms CREATE FUNCTION Time: 1.207 ms id | currentpatch | currentversion | permissions | finished | message | previouspatch | previousversion | external_id ----+--------------+----------------+-------------+----------------------------+-------------------+---------------+-----------------+------------- 1 | 0 | OMERO4 | -35 | 2009-07-21 13:05:08.743145 | Database ready. | 0 | OMERO4 | 2 | 0 | OMERO4.1 | -35 | 2010-07-26 15:39:31.418108 | Database updated. | 0 | OMERO4 | 3 | 0 | OMERO4.2 | -35 | | Updating | 0 | OMERO4.1 | (3 rows) Time: 0.205 ms id | description | permissions | name | version | creation_id | external_id | group_id | owner_id | update_id ----+-------------+-------------+---------+---------+-------------+-------------+----------+----------+----------- 0 | | -103 | system | 0 | 0 | | 0 | 0 | 0 1 | | -103 | user | 0 | 0 | | 0 | 0 | 0 2 | | -103 | default | 0 | 0 | | 0 | 0 | 0 3 | | -103 | guest | 0 | 0 | | 0 | 0 | 0 4 | BSCL | -103 | BSCL | 0 | 367035 | | 0 | 5 | 367273 (5 rows) Time: 0.165 ms id | permissions | version | child | creation_id | external_id | group_id | owner_id | update_id | parent | child_index ----+-------------+---------+-------+-------------+-------------+----------+----------+-----------+--------+------------- 0 | -35 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 1 | -35 | 0 | 0 | 0 | | 0 | 0 | 0 | 1 | 1 2 | -35 | 0 | 1 | 0 | | 0 | 0 | 0 | 3 | 0 3 | -1 | 0 | 2 | 61 | | 0 | 0 | 61 | 0 | 0 4 | -1 | 0 | 3 | 68 | | 0 | 0 | 68 | 0 | 0 5 | -1 | 0 | 3 | 157 | | 0 | 0 | 157 | 1 | 1 6 | -1 | 0 | 2 | 171 | | 0 | 0 | 171 | 1 | 1 7 | -1 | 0 | 4 | 300 | | 0 | 2 | 300 | 2 | 0 9 | -1 | 0 | 5 | 15356 | | 0 | 2 | 15356 | 0 | 0 20 | -1 | 0 | 4 | 324724 | | 0 | 2 | 324724 | 1 | 1 11 | -1 | 0 | 6 | 15560 | | 0 | 2 | 15560 | 2 | 0 12 | -1 | 0 | 6 | 15560 | | 0 | 2 | 15560 | 1 | 1 13 | -1 | 0 | 7 | 29983 | | 0 | 2 | 29983 | 2 | 0 14 | -1 | 0 | 7 | 29983 | | 0 | 2 | 29983 | 1 | 1 24 | -1 | 0 | 10 | 468674 | | 0 | 5 | 468674 | 4 | 0 19 | -1 | 0 | 8 | 299712 | | 0 | 2 | 299712 | 0 | 0 21 | -1 | 0 | 8 | 367178 | | 0 | 5 | 367178 | 4 | 2 25 | -1 | 0 | 10 | 468674 | | 0 | 5 | 468674 | 2 | 1 18 | -1 | 0 | 8 | 146398 | | 0 | 2 | 146398 | 1 | 1 22 | -1 | 0 | 9 | 367453 | | 0 | 5 | 367453 | 4 | 0 23 | -1 | 0 | 9 | 367453 | | 0 | 5 | 367453 | 1 | 1 26 | -1 | 0 | 10 | 468674 | | 0 | 5 | 468674 | 1 | 2 27 | -1 | 0 | 4 | 473656 | | 0 | 5 | 473656 | 4 | 2 16 | -1 | 0 | 5 | 146270 | | 0 | 2 | 146270 | 1 | 1 28 | -1 | 0 | 5 | 473671 | | 0 | 5 | 473671 | 4 | 2 (25 rows) Time: 0.727 ms CREATE FUNCTION Time: 3.599 ms CREATE FUNCTION Time: 1.709 ms