• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Renamed directory to postgresql

fixed a bug that i caused by switching a $ to a : in a db_write_blob call

Fixed aD's incorrect use of nvl2

Fixed aD's reuse of the dimensional var which messed up the QD

Accidently added.

updated for postgres

cleanup

deleted unneeded files

fixed outer join bugs

finished cleanup of data-model, it now loads without errors

fixed more syntax errors

more cleanup

more cleanup

minor cleanup

added query files for ad_table calls

    • -0
    • +52
    /openacs-4/packages/download/www/admin/report-one-user-oracle.xql
  1. … 8 more files in changeset.
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