OpenACS / openacs-4 / packages / acs-messaging / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 28 Dec
Commits this week: 0
Total Lines of Code (LoC): 2,860
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 02 Mar 2003
11:32 pm

donb

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

Options
    • -3
    • +3
    ./acs-messaging-create.sql
    • -10
    • +10
    ./acs-messaging-drop.sql
    • -13
    • +13
    ./acs-messaging-packages.sql
  4. … 51 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -3
    • +3
    ./acs-messaging-create.sql
    • -5
    • +5
    ./acs-messaging-packages.sql
  3. … 53 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -3
    • +3
    ./acs-messaging-create.sql
    • -5
    • +5
    ./acs-messaging-packages.sql
  3. … 53 more files in changeset.
Sunday 09 Dec 2001
10:08 pm

donb

Fixed some errors in my earlier hacking on hierarchical queries...

Options
    • -1
    • +2
    ./acs-messaging-create.sql
  2. … 3 more files in changeset.
5:21 am

donb

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!

Options
    • -1
    • +8
    ./acs-messaging-create.sql
    • -2
    • +2
    ./acs-messaging-packages.sql
  3. … 17 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

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

Options
    • -26
    • +20
    ./acs-messaging-create.sql
    • -6
    • +4
    ./acs-messaging-packages.sql
  3. … 61 more files in changeset.
Thursday 01 Nov 2001
8:01 pm

donb

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

Options
    • -24
    • +30
    ./acs-messaging-packages.sql
  2. … 2 more files in changeset.
Wednesday 19 Sep 2001
2:54 am

donb

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

file upload in bboard.

Options
    • -4
    • +7
    ./acs-messaging-packages.sql
  2. … 5 more files in changeset.
Wednesday 29 Aug 2001
8:46 pm

arjun

Fixing typo.

Options
    • -2
    • +2
    ./acs-messaging-packages.sql
Tuesday 24 Jul 2001
3:50 pm

jong

added missing declare

Options
    • -3
    • +4
    ./acs-messaging-packages.sql
Thursday 05 Jul 2001
11:11 pm

lukep

add tree_sortkey to acs_messages to enable hierarchical queries on the reply_to field

Options
    • -2
    • +93
    ./acs-messaging-create.sql
    • -3
    • +8
    ./acs-messaging-drop.sql
    • -9
    • +14
    ./acs-messaging-packages.sql
    • -3
    • +3
    ./acs-messaging-views.sql
Thursday 14 Jun 2001
7:03 am

jong

Applied patch from Vinod.

Thanks!

Fixed many little ommisions and drop scripts, etc.

Options
    • -4
    • +3
    ./acs-messaging-create.sql
    • -4
    • +47
    ./acs-messaging-drop.sql
    • -134
    • +181
    ./acs-messaging-packages.sql
Wednesday 06 Jun 2001
5:37 pm

jong

fixed included files syntax

Options
    • -3
    • +3
    ./acs-messaging-create.sql
Friday 01 Jun 2001
3:02 pm

donb

Changed parameters to use the new "p_" convention, for the most part.

Options
    • -3
    • +3
    ./acs-messaging-create.sql
    • -215
    • +212
    ./acs-messaging-packages.sql
  3. … 3 more files in changeset.
Wednesday 23 May 2001
6:39 pm

jong

changed dir structure

Options
    • -0
    • +242
    ./upgrade/upgrade-4.0-4.0.1a.sql
    • -0
    • +12
    ./upgrade/upgrade-4.0.1-4.1.sql
    • -0
    • +49
    ./upgrade/upgrade-4.0.1a-4.0.1.sql
    • -0
    • +658
    ./upgrade/upgrade-4.1-4.1.1.sql
  5. … 6 more files in changeset.
6:38 pm

jong

Initial checkin after changing directory name.

Options
    • -0
    • +139
    ./acs-messaging-create.sql
    • -0
    • +20
    ./acs-messaging-drop.sql
    • -0
    • +493
    ./acs-messaging-packages.sql
    • -0
    • +24
    ./acs-messaging-views.sql