• last updated 15 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -0
    • +1
    ./sql/oracle/survey-notifications-init.sql
    • -5
    • +5
    ./sql/oracle/survey-package-create.sql
  1. … 274 more files in changeset.
Adding catalog file.

    • -0
    • +330
    ./catalog/survey.en_US.ISO-8859-1.xml
using named parameters in call to acs_sc_impl.new to avoid mismatch with new optional pretty name parameter

    • -3
    • +3
    ./sql/oracle/survey-notifications-init.sql
  1. … 26 more files in changeset.
Timezonizing

    • -1
    • +1
    ./www/admin/responses-export-oracle.xql
adding timezone support

  1. … 6 more files in changeset.
Added noquote references. Resovles bug#585

Moved function call to nvl/coalesce

    • -3
    • +5
    ./sql/oracle/survey-package-create.sql
added missing ;

Replace function call with nvl in survey_response.initial_user_id

    • -3
    • +5
    ./sql/oracle/survey-package-create.sql
Speed up survey_response__initial_user_id by turning a function call

into coalesce.

noquote changes (Dirk Gomez)

  1. … 108 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -0
    • +26
    ./tcl/survey-notification-procs.tcl
    • -0
    • +10
    ./tcl/survey-notification-procs.xql
    • -4
    • +0
    ./www/admin/response-delete-postgresql.xql
    • -1
    • +1
    ./www/admin/responses-export-oracle.xql
  1. … 8 more files in changeset.
1. Fixed a type mismatch problem in acs-messaging for PostgreSQL that was

ignored by versions before 7.3 and therefore had been missed.

2. Fixed a problem in static pages regarding misunderstanding of how

nsv_array set works by someone who worked on it at some point.

3. Fixed a typo in static pages for PostgreSQL (misspelled function

name)

4. Fixed a typo in a query in survey.

  1. … 4 more files in changeset.
improved date formattining in export bug#125

    • -1
    • +1
    ./www/admin/responses-export-oracle.xql
fix formatting errors in output thanks to andrew grumet

118n modifications to survey

  1. … 51 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 14 more files in changeset.
forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

  1. … 7 more files in changeset.
Renamed primary key constraint on survey_responses from srvsimp_resp_response_id_pk to survey_resp_respose_id_pk to resolve a conflict with the constraint name in simple-survey.

Changed name of constraint from srvsimp_responses_resp_id_pk to

survey_responses_resp_id_pk. This will only cause an error if you install

simple survey and survey at the same time.

file survey-notification-procs.tcl was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/survey-notification-procs.tcl
file survey-notification-procs.xql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./tcl/survey-notification-procs.xql
Added support for notifications service contracts

    • -0
    • +26
    ./tcl/survey-notification-procs.tcl
    • -0
    • +10
    ./tcl/survey-notification-procs.xql
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

    • -1
    • +2
    ./www/admin/responses-export-oracle.xql
  1. … 28 more files in changeset.
fix link to view icon

fix link to "view" icon

missing perform in pl/pgsql call

    • -1
    • +1
    ./www/admin/response-delete-postgresql.xql
fix copied surveys to be disabled by default

add missing query for postgresql

fixed duplicated code