• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Oops - I'd previously committed a query with a literal substituted for

:forum_id, done back when I was hacking these queries for greater efficiency

using real test data. I was using psql so I was using literal values...

Changed the representation of tree_sortkeys from "text" to "bit varying".

    • -5
    • +3
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -3
    • +10
    ./bboard/www/message-delete-2-postgresql.xql
    • -3
    • +3
    ./bboard/www/message-move-2-postgresql.xql
  1. … 57 more files in changeset.

Changed to the new tree_sortkey comparison scheme. Mostly untested (yet)

will do so shortly!

    • -16
    • +12
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -27
    • +16
    ./bboard/www/forum-postgresql.xql
    • -8
    • +3
    ./bboard/www/message-delete-2-postgresql.xql
    • -11
    • +6
    ./bboard/www/message-move-2-postgresql.xql
    • -7
    • +5
    ./bboard/www/message-threaded-postgresql.xql

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

  1. … 11 more files in changeset.

Check the comments in postgresql.sql - my previous commit didn't quite work

as expected.

I also removed an ugly assumption made in the PG port in bboard-procs.tcl.

    • -5
    • +7
    ./bboard/tcl/bboard-procs-postgresql.xql
  1. … 1 more file in changeset.

Added "tree_left" and "tree_right" in order to optimize tree queries, which

I did for the bboard package. "LIKE (tree_sortkey || %)" never uses the

index as we thought it did, as it turns out ... see postgresql.sql for

example queries that do.

    • -1
    • +3
    ./bboard/sql/postgresql/bboard-create.sql
    • -3
    • +5
    ./bboard/sql/postgresql/bboard-views.sql
  1. … 1 more file in changeset.

First round of speedups for verious permissions issues. Key finding is that

the all_object_party_privilege_map is speedy in PostgreSQL and apparently in

Oracle, as well (having re-read some of the optimization threads).

    • -12
    • +16
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -1
    • +1
    ./bboard/www/message-delete-2-oracle.xql
  1. … 18 more files in changeset.

Added a comment to this file ...

    • -1
    • +7
    ./bboard/sql/postgresql/bboard-views.sql

1. Fixed a boneheaded error in the bootstrapper: "AvailablePool" was being

submitted to a case-sensitive check. Of course AOLserver parameters are

case-insensitive.

2. A recently submitted patch to the db routine that PSQL's source broke

the code if you haven't started postmaster with the "-i" option.

3. Bboard was very, very slow in PG. It is now much faster.

    • -47
    • +13
    ./bboard/sql/postgresql/bboard-views.sql
  1. … 2 more files in changeset.
initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

    • -290
    • +593
    ./ticket-tracker/sql/oracle/ttracker-workflow-create.sql
  1. … 8 more files in changeset.
initial revision of acs-workflow-4.3

    • -365
    • +585
    ./ticket-tracker/sql/postgresql/ttracker-workflow-create.sql

1. Modified the Javascript "check/uncheck all boxes" code in the APM

package install page so that it still works if javascript's disabled.

2. Slight rewrite of a view in bboard.

3. Skin works in OpenACS Oracle/PG - changed info file to reflect this.

4. Added clean error handling to wimpy point attachment upload page.

    • -8
    • +12
    ./bboard/sql/postgresql/bboard-views.sql
  1. … 3 more files in changeset.
initial revision of acs-workflow-4.3

    • -28
    • +155
    ./acs-workflow/acs-workflow.info
  1. … 20 more files in changeset.
initial revision of acs-workflow-4.3

    • -31
    • +5
    ./acs-workflow/tcl/display-procs-oracle.xql
    • -31
    • +5
    ./acs-workflow/tcl/display-procs-postgresql.xql
    • -18
    • +17
    ./acs-workflow/tcl/display-procs.tcl
    • -27
    • +54
    ./acs-workflow/tcl/graph-procs.tcl
    • -205
    • +665
    ./acs-workflow/tcl/workflow-procs-oracle.xql
    • -220
    • +615
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
    • -497
    • +1030
    ./acs-workflow/tcl/workflow-procs.tcl
    • -118
    • +171
    ./acs-workflow/tcl/workflow-procs.xql
    • -80
    • +10
    ./acs-workflow/www/assign-yourself.tcl
    • -63
    • +4
    ./acs-workflow/www/assignee-add-2.tcl
    • -2
    • +8
    ./acs-workflow/www/assignee-add-oracle.xql
    • -2
    • +8
    ./acs-workflow/www/assignee-add-postgresql.xql
  1. … 220 more files in changeset.
initial revision of acs-workflow-4.3

    • -1
    • +2
    ./acs-workflow/sql/oracle/acs-workflow-create.sql
    • -1
    • +1
    ./acs-workflow/sql/oracle/acs-workflow-drop.sql
    • -2
    • +0
    ./acs-workflow/sql/oracle/jobs-kill.sql
    • -2
    • +0
    ./acs-workflow/sql/oracle/jobs-start.sql
    • -114
    • +197
    ./acs-workflow/sql/oracle/sample-article-create.sql
    • -1
    • +1
    ./acs-workflow/sql/oracle/sample-article-drop.sql
    • -121
    • +292
    ./acs-workflow/sql/oracle/sample-expenses-create.sql
    • -0
    • +541
    ./acs-workflow/sql/oracle/upgrade-4.1.1-4.3.sql
    • -0
    • +46
    ./acs-workflow/sql/oracle/wf-callback-package-body.sql
    • -0
    • +34
    ./acs-workflow/sql/oracle/wf-callback-package-head.sql
    • -55
    • +3
    ./acs-workflow/sql/oracle/wf-callback-package.sql
    • -297
    • +410
    ./acs-workflow/sql/oracle/wf-core-create.sql
    • -3
    • +6
    ./acs-workflow/sql/oracle/wf-core-drop.sql
    • -0
    • +1973
    ./acs-workflow/sql/oracle/workflow-case-package-body.sql
  1. … 137 more files in changeset.

Bug fixes in the postgres ports of these packages ...

    • -3
    • +5
    ./bboard/tcl/bboard-procs-postgresql.xql
  1. … 2 more files in changeset.

1. Added a new Tcl procedure to the content repository's library, named

cr_write_content, which properly writes content to the connection

regardless of RDBMS and storage type. This simplified a bunch of stuff

(which explains the removed files).

2. Fixed a lot of general comments issues regarding HTML vs. Plain/Text,

attachments, etc.

3. Partially ported glossary.

    • -11
    • +11
    ./bboard/tcl/bboard-procs-oracle.xql
    • -15
    • +12
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -26
    • +0
    ./bboard/www/attachment-postgresql.xql
    • -2
    • +1
    ./ticket-tracker/tcl/ttracker-procs.tcl
  1. … 73 more files in changeset.

Directory package now ready for testing. mp3jukebox is now mp3-jukebox.

    • -35
    • +0
    ./mp3jukebox/bin/mp3_info_determine
    • -545
    • +0
    ./mp3jukebox/sql/oracle/mp3jukebox-create.sql
  1. … 51 more files in changeset.
added perl MP3 module installation instructions

initial port, not tested with oracle

    • -0
    • +137
    ./mp3-jukebox/mp3-jukebox.info
    • -0
    • +22
    ./mp3-jukebox/bin/mp3_file_scan
    • -0
    • +35
    ./mp3-jukebox/bin/mp3_info_determine
    • -0
    • +545
    ./mp3-jukebox/sql/oracle/mp3-jukebox-create.sql
    • -0
    • +67
    ./mp3-jukebox/sql/oracle/mp3-jukebox-drop.sql
    • -0
    • +396
    ./mp3-jukebox/sql/postgresql/mp3-jukebox-create.sql
    • -0
    • +80
    ./mp3-jukebox/sql/postgresql/mp3-jukebox-drop.sql
    • -0
    • +38
    ./mp3-jukebox/tcl/mp3-procs.tcl
    • -0
    • +33
    ./mp3-jukebox/tcl/scanner-procs.tcl
    • -0
    • +21
    ./mp3-jukebox/www/index-oracle.xql
    • -0
    • +27
    ./mp3-jukebox/www/index.adp
    • -0
    • +26
    ./mp3-jukebox/www/index.tcl
    • -0
    • +20
    ./mp3-jukebox/www/index.xql
    • -0
    • +7
    ./mp3-jukebox/www/master.adp
  1. … 91 more files in changeset.