• last updated 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Moved function call to nvl/coalesce

added missing ;

Replace function call with nvl in survey_response.initial_user_id

Speed up survey_response__initial_user_id by turning a function call

into coalesce.

merge of 4.6.3b1 to HEAD

  1. … 17 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.

merge from oacs-4-6

    • -29
    • +38
    ./postgresql/survey-notifications-init.sql
  1. … 26 more files in changeset.
call survey-notifications-init.sql

merge fixes into 4.6 branch

    • -1
    • +1
    ./postgresql/survey-notifications-init.sql
source notifications init file

source notificiations-init.sql file

fix service contract file. unported from oracle.

    • -27
    • +37
    ./postgresql/survey-notifications-init.sql
fix question_delete (change to remove)

fix abstract data type for postgresql, add blob

remove "untested" comment

    • -1
    • +0
    ./postgresql/survey-notifications-init.sql
clean up del/remove functions

error v_section_row used rather than v_question_row bug 1790/patch 495

fix postgresql data model

  1. … 2 more files in changeset.
fix foreign key constraint to refer to cr_revisions instead of cr_items

add "blob" as choice for survey_questions.abstract_data_type check constraint

remove scored survey stuff from drop script, it isn't created so does not

need to be dropped.

fix postgresql create and drop scripts

  1. … 1 more file in changeset.
initial import

    • -0
    • +242
    ./oracle/survey-create.sql
    • -0
    • +60
    ./oracle/survey-drop.sql
    • -0
    • +62
    ./oracle/survey-notifications-init.sql
    • -0
    • +484
    ./oracle/survey-package-create.sql
    • -0
    • +4
    ./oracle/survey-package-drop.sql
    • -0
    • +567
    ./postgresql/survey-create.sql
    • -0
    • +76
    ./postgresql/survey-drop.sql
    • -0
    • +62
    ./postgresql/survey-notifications-init.sql
  1. … 161 more files in changeset.