• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
initial revision

    • -0
    • +317
    /openacs-4/packages/acs-messaging/sql/postgres/acs-create.sql
more cleanup

more cleanup

Fixed more syntax errors

more porting work

Changing file names.

modified acs_object scripts and fixed syntax error. This will now load

took out Oracle package dependency

started porting work

created postgresql sql directory

    • -0
    • +298
    /openacs-4/packages/cms/sql/postgresql/cms-content-methods.sql
    • -0
    • +243
    /openacs-4/packages/cms/sql/postgresql/cms-create.sql
    • -0
    • +4
    /openacs-4/packages/cms/sql/postgresql/cms-drop.sql
    • -0
    • +115
    /openacs-4/packages/cms/sql/postgresql/cms-fix.sql
    • -0
    • +415
    /openacs-4/packages/cms/sql/postgresql/cms-forms.sql
    • -0
    • +60
    /openacs-4/packages/cms/sql/postgresql/cms-update.sql
    • -0
    • +295
    /openacs-4/packages/cms/sql/postgresql/cms-widgets.sql
    • -0
    • +131
    /openacs-4/packages/cms/sql/postgresql/rel-test.sql
cleanup

removed cancel and resume links from cases that are finished - use of these links throws an error

fixed oracle db api so that db_exec_plsql command would still work after the passed in sql query is converted to an empty string

fixed outer join query

fixed some bugs discovered by Vinod Kurup

added file_size to pg datamodel, pg queries. Moved calc (size = bytes/1024) from tcl to sql

Added db_map for oracle-specific partial queries.

Fixed problem caused by dimensional being used twice (renamed to

dimensional_html)

Fixed problem that had set archive_type_id to 'All' (not an integer)

aD used the var 'dimensional' in a query and then reassigned it, so when

the query dispatcher tries to acces 'dimensional', it accesses the wrong

one. renamed the second use to dimensional_html

added partial queries

Added partial queries

more workflow fixup

more workflow cleanup

  1. … 4 more files in changeset.
updated date types to timestamp, eliminated nvl

Port queries/query extractor output

    • -100
    • +10
    /openacs-4/packages/acs-subsite/tcl/package-procs.xql
  1. … 166 more files in changeset.
initial version

more debugging of workflow

fixed up wf after initial testing

  1. … 3 more files in changeset.
fixed more queries

fixed sequences. Updated functions. Improved drop script

changed to consistent sequence names