• last updated 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typos

  1. … 17 more files in changeset.
- add "cascade" to make uninstall clean

Merging commits from oacs-5-2 branch to HEAD.

    • -0
    • +234
    ./postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  1. … 1 more file in changeset.
file upgrade-5.2.0d3-5.2.0d4.sql was initially added on branch oacs-5-2.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql
Specify boolean as function parameter for security_inherit_p so we use the correct version of the content_folder__new function.

    • -0
    • +234
    ./postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  1. … 1 more file in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

    • -11
    • +603
    ./postgresql/static-page-pb.sql
    • -6
    • +5
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
  1. … 2274 more files in changeset.
typos in the scripts

    • -13
    • +605
    ./postgresql/static-page-pb.sql
    • -6
    • +5
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
make static pages work with tip 43; bump to 5.2.0d2, upgrade oracle, postgres

    • -0
    • +4
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -0
    • +180
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  1. … 3 more files in changeset.
Fixed relative path, removed extra single quotes not needed outside plpgsql

function.

    • -6
    • +6
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +605
    ./oracle/upgrade/upgrade-4.3-5.0d1.sql
  1. … 23 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 273 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 18 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 14 more files in changeset.
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

    • -589
    • +21
    ./oracle/static-pages-create.sql
    • -0
    • +45
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -585
    • +2
    ./postgresql/static-pages-create.sql
    • -0
    • +26
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
  1. … 28 more files in changeset.
Now correctly sets mime type using sp_maybe_create_new_mime_type,

rather than always using text/html.

    • -1
    • +20
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
  1. … 3 more files in changeset.
Upgrade script now properly converts existing filenames from page to

server root relative, for both Oracle and Postgres.

    • -1
    • +8
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

    • -1
    • +10
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +5
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
  1. … 4 more files in changeset.
file upgrade-4.2a-4.3.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
- Name of root folder is now unique in the CR even if have multiple

package instances, for both Oracle and Postgres.

- All Postgres functions now defined with "create or replace".

    • -0
    • +15
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
Moved Postgres functions and bodies out of static-pages-create.sql

into separate files (just like for Oracle) - necessary to more cleanly

support upgrade files. No other changes.

    • -585
    • +2
    ./postgresql/static-pages-create.sql
file static-page-pb.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./postgresql/static-page-pb.sql
Moved Oracle package headers and bodies out of static-pages-create.sql

into separate files - necessary to more cleanly support upgrade files.

Also added a few comments. No other changes.

    • -589
    • +19
    ./oracle/static-pages-create.sql
file static-page-pb.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/static-page-pb.sql
file static-page-ph.sql was initially added on branch oacs-4-6.

    • -0
    • +0
    ./oracle/static-page-ph.sql
Added sp_folder_get_tree_sortkey function to the drop script

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

    • -77
    • +56
    ./postgresql/static-pages-create.sql
  1. … 62 more files in changeset.
Removing unused static-pages-sws files from sql/postgresql

    • -40
    • +0
    ./postgresql/static-pages-sws-drop.sql
Fixed file update error in postgreql. It adds an mtime column, update your

datamodel on PG. Code checks for storage_type to run the correct queries/code

for Oracle/PG.

    • -7
    • +19
    ./postgresql/static-pages-create.sql
  1. … 4 more files in changeset.

Removed some misnamed files from file-storage and removed a garbage file

from static-pages.

    • -846
    • +0
    ./postgresql/#static-pages-create.sql#
  1. … 6 more files in changeset.