forums-messages-package-create.sql

  • last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merge of 4.6.3b1 to HEAD

  1. … 64 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. … 39 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

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

  1. … 56 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

  1. … 54 more files in changeset.
create necessary index, make forums_message__root_message_id isstrict, icachable, upgrade script

  1. … 5 more files in changeset.
merge from oacs-4-6

  1. … 103 more files in changeset.
Added "last_post" column to the forums table and "last_child_post" column

to the forums messages table to track these values. Previously the code

was abusing the related object's last_modified field and it didn't bother

tracking the date of the last reply to a thread.

  1. … 16 more files in changeset.
message deletion fixes

  1. … 4 more files in changeset.
added coalesces (where there's nvl's in the oracle version) to fix the perm bug where reg'd users can't see forums or posts

  1. … 1 more file in changeset.
some more porting to postgres

    • -142
    • +159
    ./forums-messages-package-create.sql
  1. … 9 more files in changeset.
fixing calls to tree functions in postgres queries

  1. … 3 more files in changeset.
now loads (and unloads) in postgres

  1. … 12 more files in changeset.
adding forums_message.name

    • -36
    • +45
    ./forums-messages-package-create.sql
  1. … 6 more files in changeset.
updating last modified times so we can easily keep track of newness

  1. … 3 more files in changeset.
added beginning of PG port

    • -0
    • +190
    ./forums-messages-package-create.sql
  1. … 10 more files in changeset.