static-pages-procs-postgresql.xql

  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
make static pages work with tip 43; bump to 5.2.0d2, upgrade oracle, postgres

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

  1. … 18 more files in changeset.
1. Fixed a type mismatch problem in acs-messaging for PostgreSQL that was

ignored by versions before 7.3 and therefore had been missed.

2. Fixed a problem in static pages regarding misunderstanding of how

nsv_array set works by someone who worked on it at some point.

3. Fixed a typo in static pages for PostgreSQL (misspelled function

name)

4. Fixed a typo in a query in survey.

  1. … 4 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.

    • -20
    • +46
    ./static-pages-procs-postgresql.xql
  1. … 34 more files in changeset.
www/page-visit.tcl now works properly with files under package

directories and under the global www/ page root.

  1. … 3 more files in changeset.
Now correctly sets mime type using sp_maybe_create_new_mime_type,

rather than always using text/html.

    • -12
    • +8
    ./static-pages-procs-postgresql.xql
  1. … 6 more files in changeset.
- 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.

    • -0
    • +21
    ./static-pages-procs-postgresql.xql
  1. … 6 more files in changeset.
Added mutex locking prevent errors if more than one copy of

sp_sync_cr_with_filesystem runs at once for a single package instance,

plus related changes. Changed sp_sync_cr_with_filesystem proc to a

wrapper proc which now calls sp_sync_cr_with_filesystem_internal, in

order to properly free the mutex upon any unexpected error.

  1. … 6 more files in changeset.
use cumulative_path rather than directory for item name fixes 1544/patch 360

  1. … 2 more files in changeset.
Fixed problem were content_item__get_item_id was not returning and item_id

for an item that exists. Switched to plain old select and it works fine now.

  1. … 1 more file in changeset.

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

    • -23
    • +18
    ./static-pages-procs-postgresql.xql
  1. … 62 more files in changeset.
Fixed extraneous end; in tcl/static-pages-procs-postgresql.xql

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.

    • -3
    • +14
    ./static-pages-procs-postgresql.xql
  1. … 4 more files in changeset.
Fixed comment display to correctly display comment content when enabled

  1. … 2 more files in changeset.
More fixes to static_page__grant/revoke permission and static-pagses-procs-postgresql.xql

  1. … 4 more files in changeset.
Fixed sp_grant_or_revoke_matching_permissions

Fixed insert into cr_revisions to store relative file path

Fixed static folders. Now stores file path relative to installation root and uses cr_fs_path to get the full file path.

    • -12
    • +10
    ./static-pages-procs-postgresql.xql
  1. … 4 more files in changeset.
*** empty log message ***

  1. … 7 more files in changeset.
Fixed info file for postgresql and fixed Oracle version

  1. … 8 more files in changeset.
Postgresql ported - still needs modifications to work with static-pages. Oracle not tested and probably broken

    • -21
    • +48
    ./static-pages-procs-postgresql.xql
  1. … 6 more files in changeset.
stores content as "file" in content repository. Comments working

    • -9
    • +20
    ./static-pages-procs-postgresql.xql
  1. … 2 more files in changeset.
Datamodel loads in postgresql. Beginning work on Tcl

    • -7
    • +11
    ./static-pages-procs-postgresql.xql
  1. … 2 more files in changeset.
Now it's close to work

    • -50
    • +61
    ./static-pages-procs-postgresql.xql
  1. … 5 more files in changeset.
Start of postgresql port, if someone else want help fell free to edit this files

    • -0
    • +108
    ./static-pages-procs-postgresql.xql
  1. … 12 more files in changeset.