• last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
modified search interface to use FtsEngineDriver contract for searching

    • -0
    • +62
    ./packages/cms/www/modules/search/index-oracle.xql
    • -0
    • +63
    ./packages/cms/www/modules/search/index-postgresql.xql
converted mail_notifications to use ad_proc instead of proc

*** empty log message ***

added service content support to convert CR into a content provider for search

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

    • -2
    • +3
    ./packages/calendar/www/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

    • -4
    • +4
    ./packages/calendar/www/cal-weekview.tcl
fixed bogus ns_log command in rp_report_error

Updating js tree...

minor doc fixes

    • -4
    • +4
    ./packages/acs-mail/www/doc/openacs-mail.html
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.

    • -11
    • +30
    ./packages/acs-mail/sql/oracle/acs-mail-nt-create.sql
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
    ./packages/calendar/www/cal-dayview.tcl
    • -5
    • +30
    ./packages/calendar/www/cal-listview.tcl
    • -3
    • +22
    ./packages/calendar/www/cal-monthview.tcl
    • -5
    • +29
    ./packages/calendar/www/cal-weekview.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
    • +40
    ./packages/calendar/www/admin/cal-item-permissions-postgresql.xql
    • -0
    • +28
    ./packages/calendar/www/admin/cal-item-permissions.xql
    • -0
    • +28
    ./packages/calendar/www/admin/calendar-permissions-postgresql.xql
    • -0
    • +28
    ./packages/calendar/www/admin/calendar-permissions.xql
    • -0
    • +46
    ./packages/calendar/www/admin/calendar-preferences-postgresql.xql
    • -0
    • +24
    ./packages/calendar/www/admin/index-oracle.xql
    • -0
    • +24
    ./packages/calendar/www/admin/index-postgresql.xql
    • -0
    • +18
    ./packages/calendar/www/admin/one-oracle.xql
    • -0
    • +18
    ./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

    • -8
    • +8
    ./packages/acs-templating/tcl/filter-procs.tcl
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.

    • -1
    • +2
    ./packages/spam/sql/oracle/spam-create.sql
    • -0
    • +18
    ./packages/spam/sql/oracle/spam-drop.sql
    • -56
    • +76
    ./packages/spam/sql/oracle/spam-packages.sql
    • -0
    • +35
    ./packages/spam/sql/postgresql/spam-create.sql
    • -0
    • +21
    ./packages/spam/sql/postgresql/spam-drop.sql
    • -0
    • +318
    ./packages/spam/sql/postgresql/spam-packages.sql
    • -0
    • +5
    ./packages/spam/sql/postgresql/spam-views.sql
    • -0
    • +72
    ./packages/spam/tcl/spam-procs-oracle.xql
    • -0
    • +89
    ./packages/spam/tcl/spam-procs-postgresql.xql
    • -0
    • +80
    ./packages/spam/tcl/spam-procs.xql
    • -0
    • +55
    ./packages/spam/www/index-oracle.xql
    • -0
    • +62
    ./packages/spam/www/index-postgresql.xql
    • -0
    • +4
    ./packages/spam/www/index.xql
  1. … 31 more files in changeset.