Index: openacs-4/packages/acs-bootstrap-installer/db-init-checks-postgresql.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-bootstrap-installer/db-init-checks-postgresql.tcl,v diff -u -N -r1.4.2.1 -r1.4.2.2 --- openacs-4/packages/acs-bootstrap-installer/db-init-checks-postgresql.tcl 4 Oct 2002 07:24:20 -0000 1.4.2.1 +++ openacs-4/packages/acs-bootstrap-installer/db-init-checks-postgresql.tcl 14 Jan 2003 21:41:42 -0000 1.4.2.2 @@ -35,10 +35,13 @@ nsv_set ad_database_version . $version } - if { $version < 7.1 } { - append my_errors "
  • Your installed version of Postgres is too old. Please install Postgres V7.1 or later.\n" + if { $version < 7.2 } { + append my_errors "
  • Your installed version of Postgres is too old. Please install PostgreSQL 7.2 or later.\n" set my_error_p 1 - } + } elseif { [string equal $version "7.3"] } + append my_errors "
  • PostgreSQL 7.3 is not supported at this moment. Please use 7.2.3.\n" + set my_error_p 1 + } if { [catch { ns_pg_bind 1row $db "select count(*) from pg_class" }] } { append my_errors "
  • Your Postgres driver is too old. You need to update.\n" @@ -59,24 +62,8 @@ set my_error_p 1 } - # DRB: The PG user has to have "createuser" privs for the PG 7.1 install to work. Not necessary for PG 7.2 + # RBM: Remove check for 7.1 since we don't support it anymore. 2002-01-14 - if { $version == 7.1 } { - if { [catch { ns_db dml $db "create function __test__() returns integer as 'select 1' language 'sql'" } errmsg] } { - append my_errors "
  • Unexpected error creating SQL function. Check your AOLserver log for details.\n" - set my_error_p 1 - } else { - if { [catch { ns_db dml $db "update pg_proc set proname = '__test__' where proname = '__test__'" } errmsg] } { - append my_errors "
  • To install the kernel datamodel in PostgreSQL 7.1 database user named in your AOLserver database pools must have the CREATEUSER privilege. You must drop your database and user and recreate the user, answering \"yes\" when asked if the new user should be able to create other users.

    After installation is complete we recommend that you remove this privilege using the following command:

    alter user your_acs_postgres_user nocreatuser\;

    If you upgrade to PostgreSQL 7.2 you can avoid the need to grant this privilege." - set my_error_p 1 - } - if { [catch { ns_db dml $db "drop function __test__();" } errmsg] } { - append my_errors "

  • An unexpected error was encountered while dropping test function:
    $errmsg
    \n" - set my_error_p 1 - } - } - } - ns_db releasehandle $db if { [info exists my_error_p] } {