OpenACS / openacs.org-dev / packages / notifications / tcl

sweep-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 40
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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 29 Nov 2004
7:21 am

andrewg

Temporary mod to cleanup_notifications.select_notification_ids. Old notifications were hanging around, and as they piled up where bogging down sweep_notifications.select_notifications, which computes a product of notifications and notification_requests that can become quite large. Something's going wrong with the outer join, because querying notification_user_map shows that sent_date is not null for all rows. So we're getting non-matching rows for some reason. Have to figure out why. For now we've simply added a clause that permits deletion of any notification with notif_date greater than 30 days old.

Options
    • -1
    • +1
    ./sweep-procs-postgresql.xql
6:05 am

andrewg

Committing an uncommitted change, so that we can have a clean record of the next change, which I'm about to make.

Options
    • -2
    • +1
    ./sweep-procs-postgresql.xql
Friday 04 Jul 2003
11:00 pm

donb

Applied Robert Locke's fix for the cleanup proc

Options
    • -3
    • +6
    ./sweep-procs-postgresql.xql
Wednesday 12 Feb 2003
2:16 pm

jeffd

commit changes from Dons fixes for sweeper and Bart for From as sender and reply-to as notifications-blah

Options
    • -28
    • +22
    ./sweep-procs-postgresql.xql
  2. … 10 more files in changeset.
Tuesday 08 Oct 2002
5:46 pm

rmello

OpenACS update 2002-10-08

Options
    • -3
    • +3
    ./sweep-procs-postgresql.xql
  2. … 2813 more files in changeset.
Monday 05 Aug 2002
11:38 pm

rmello

OpenACS update 2002-08-05

Options
    • -0
    • +3
    ./sweep-procs-postgresql.xql
  2. … 58 more files in changeset.
Tuesday 09 Jul 2002
7:34 pm

rmello

Importing OpenACS 4.5devel 2002-06-09

Options
    • -0
    • +0
    ./sweep-procs-postgresql.xql
  2. … 7583 more files in changeset.
7:34 pm

rmello

Initial revision

Options
    • -0
    • +44
    ./sweep-procs-postgresql.xql
  2. … 7583 more files in changeset.