• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Port queries

Order by tree_sortkey, remove redundant subquery. Not alphabetical,

but at least it's the same as the Oracle version.

changed db_get_info_from_db to db_get_info in cal-listview.tcl

added on delete cascade so that items still in the queue can be deleted without triggering RI constraint error

modified cal-weekview-postgresql.xql & cal-weekview.tcl

fixed bogus ns_log command in rp_report_error

Updating js tree...

minor doc fixes

added OutgoingSender parameter to acs-kernel

fixed to set creation_user only if party_from is actually a user.

fixed to use the acs-kernel param OutgoingSender if party_from doesn't have an email address.

reset party_from to -1

added install check to be sure that NotificationSender has a valid email address

added install check to be sure that NotificationSender has a valid email address

Oops on colunm name, fixed ordering

Fixed context_bar to more closely mimic oracle behavior

changed nvl to coalesce in tcl file

    • -11
    • +38
    /openacs-4/packages/calendar/www/cal-dayview.tcl
    • -3
    • +22
    /openacs-4/packages/calendar/www/cal-monthview.tcl
*** empty log message ***

updated the info file

*** empty log message ***

replace unique with distinct in the cal-options-postgresql.xql

Datamodel should be working

updated

xql files for admin dir

    • -0
    • +24
    /openacs-4/packages/calendar/www/admin/index-oracle.xql
    • -0
    • +24
    /openacs-4/packages/calendar/www/admin/index-postgresql.xql
    • -0
    • +18
    /openacs-4/packages/calendar/www/admin/one-oracle.xql
    • -0
    • +18
    /openacs-4/packages/calendar/www/admin/one-postgresql.xql
removed FILTER_ABORT code from template::forward as the RP doesn't support the catching of the FILTER_ABORT error as a control structure. Removal of the FILTER_ABORT code allows code to be executed after a template::forward command

fixed definition of item relationships

initial port to postgresql. modified to use the new acs-mail package

which uses acs-content-repository instead of acs-content.

    • -0
    • +35
    /openacs-4/packages/spam/sql/postgresql/spam-create.sql
    • -0
    • +21
    /openacs-4/packages/spam/sql/postgresql/spam-drop.sql
    • -0
    • +5
    /openacs-4/packages/spam/sql/postgresql/spam-views.sql
    • -0
    • +72
    /openacs-4/packages/spam/tcl/spam-procs-oracle.xql
    • -0
    • +89
    /openacs-4/packages/spam/tcl/spam-procs-postgresql.xql
    • -6
    • +33
    /openacs-4/packages/spam/tcl/spam-procs.tcl
    • -0
    • +80
    /openacs-4/packages/spam/tcl/spam-procs.xql
    • -0
    • +55
    /openacs-4/packages/spam/www/index-oracle.xql
    • -0
    • +62
    /openacs-4/packages/spam/www/index-postgresql.xql
    • -0
    • +4
    /openacs-4/packages/spam/www/index.xql
  1. … 31 more files in changeset.
Fixed info file for postgresql and fixed Oracle version

changed gmake-install-headers to gmake install-all-headers

fixed closing of cursors after an exception

    • -3
    • +1
    /openacs-4/packages/cms/tcl/perm-procs.tcl
version update with new common/ packages