navigation-procs-postgresql.xql

  • last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
removing xql files for navigation-procs.tcl that I forgot to remove when merging caching of context bar from 4-6 to trunk

  1. … 1 more file in changeset.
don't query for context bar on every hit since data is cached in site_node nsvs. No need for query files so removed. fixes bug 207/patch 65 Peter Marklund

  1. … 2 more files in changeset.

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.

Switched tree-based queries to a tree-using form, which will greatly enhance

scalability...

  1. … 26 more files in changeset.
fixed context bar query as suggested by Luke Pond

  1. … 2 more files in changeset.

Ignore the remove, it was due to cockpit error.

The rest is minor cleanup stuff.

  1. … 6 more files in changeset.
query extractor output for acs-tcl

    • -10
    • +15
    ./navigation-procs-postgresql.xql
  1. … 41 more files in changeset.

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

    • -0
    • +17
    ./navigation-procs-postgresql.xql
  1. … 6 more files in changeset.