• last updated 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

  1. … 18 more files in changeset.

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

  1. … 62 more files in changeset.

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

will do so shortly!

  1. … 8 more files in changeset.

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.

  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).

  1. … 22 more files in changeset.

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

  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.

  1. … 79 more files in changeset.

Fixed all sorts of cruft uncovered when I decided to fix the bug preventing

file upload in bboard.

  1. … 4 more files in changeset.
Don't use db_dml when calling stored procs. Use db_exec_plsql instead.

Added missing where clause in "bboard_message_set.message_set_content"

query. Thanks to Louis Zirkel for catching this.

Fix for message-edit-3 blowing up. Tested on both PG and Oracle. Thanks

go out to Louis. - Arjun

"In digging into the code I found that there is a call to

bboard_message_clear_categories which in turn calls db_dml to call a

stored proc. This doesn't seem to work, but changing the db_dml call

to db_exec_plsql seems to have resolved the issue." -- Louis Zirkel

Fixed posting error due to incorrect partialquery name.

Added patch form Luke Pond that updates bboard_garbage_collect_postgresql

so that general_comments are prevented from being garbage collected.

inital changes for openacs port

    • -0
    • +495
    ./bboard-procs-oracle.xql
    • -0
    • +461
    ./bboard-procs-postgresql.xql
    • -0
    • +221
    ./bboard-procs.xql

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2478 more files in changeset.
Initial revision

    • -0
    • +1010
    ./bboard-procs.tcl
  1. … 2478 more files in changeset.