• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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. … 52 more files in changeset.
missing query in oracle, remove dups in allowed children

    • -1
    • +28
    ./www/modules/items/children-oracle.xql
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.
display attr info when form invalid

    • -17
    • +24
    ./www/modules/types/widget-register-1.tcl
add backs signin query, remove broken links from head.adp

file signin.xql was initially added on branch oacs-4-6.

fix variable interpolation

fix bind var so value returned from content_item.new

use template::multirow api instead of the now broken direct mucking with the mutlirow

    • -40
    • +42
    ./www/modules/clipboard/index.tcl
adds -extend attribute_value for data display

fix some typos in widget-register sequence

    • -1
    • +1
    ./www/modules/types/widget-register-1.xql
    • -1
    • +1
    ./www/modules/types/widget-register-3.xql
fix a host of problems with the widget-register stuff, some still exist

    • -18
    • +5
    ./www/modules/types/widget-register-1.tcl
    • -2
    • +35
    ./www/modules/types/widget-register-1.xql
    • -1
    • +1
    ./www/modules/types/widget-register.tcl
file upgrade-4.6-4.6.1.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

    • -7
    • +7
    ./sql/postgresql/cms-content-methods.sql
    • -19
    • +19
    ./sql/postgresql/cms-permissions.sql
    • -3
    • +3
    ./sql/postgresql/cms-publishing-wf.sql
    • -25
    • +25
    ./sql/postgresql/cms-workflow.sql
    • -0
    • +146
    ./sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
  1. … 13 more files in changeset.
merge barts removal of duped cm_form_widget__set_attribute_param_value declare

merge Barts fix for duplicate content_module__new from head

merge bartt PG 7.3 fixes from HEAD

    • -1
    • +1
    ./www/modules/items/status-edit-postgresql.xql
  1. … 51 more files in changeset.
Removed duplicate function declaration.

Removed dublicate declaration of content_module__new (varchar,varchar,integer,integer,integer)

Patches to make OpenACS PG 7.3 compatible.

    • -1
    • +1
    ./www/modules/items/status-edit-postgresql.xql
  1. … 51 more files in changeset.
merge from oacs-4-6

    • -1
    • +1
    ./sql/postgresql/cms-publishing-wf.sql
    • -1
    • +1
    ./www/modules/types/index-postgresql.xql
  1. … 124 more files in changeset.
cleanup on .xql files, add rdbms tags to db specific files, clean XML, etc

    • -1
    • +1
    ./www/modules/types/index-postgresql.xql
  1. … 25 more files in changeset.
fixed bug in publishing workflow

    • -1
    • +1
    ./sql/postgresql/cms-publishing-wf.sql
warn if unable to lookup package_id

minor cleanup

    • -1
    • +1
    ./www/modules/sitemap/delete-items.tcl
minor fixes

    • -1
    • +1
    ./www/modules/items/comment-add-oracle.xql
    • -1
    • +0
    ./www/modules/items/status-edit-postgresql.xql
workflow in cms working on oracle

    • -1
    • +1
    ./www/modules/items/comments-oracle.xql
fixed relating items to other content items

    • -2
    • +2
    ./www/modules/items/relate-items-postgresql.xql
updating oracle workflow

updating oracle workflow

    • -45
    • +117
    ./sql/oracle/cms-publishing-wf.sql
    • -7
    • +14
    ./sql/postgresql/cms-publishing-wf.sql