OpenACS / openacs-4 / packages / acs-subsite / tcl

subsite-callback-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 08 May
Commits this week: 0
Total Lines of Code (LoC): 22
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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 13 Feb 2022
8:31 pm

gustafn

fix cut&paste issue

Options
    • -1
    • +1
    ./subsite-callback-procs-postgresql.xql
5:46 pm

gustafn

Fixes for Oracle 19c recursive query

Oracle has a slightly differnt syntax for CTEs require arguments, keyword "recursive" is not allowed.

This fixes the following error during initial installation:

nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00905: missing keyword

SQL:

with recursive !>>>!object_hierarchy as (

select object_type, supertype

from acs_object_types

where object_type = coalesce(:object_type, (select object_type

from acs_objects

where object_id = :object_id))

union all

select t.object_type, t.supertype

from acs_object_types t,

object_hierarchy s

where t.object_type = s.supertype

)

select distinct callback, callback_type as type

from subsite_callbacks

where event_type = :event_type

and object_type in (select object_type from object_hierarchy)

Options
    • -0
    • +30
    ./subsite-callback-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 17 Dec 2019
1:00 pm

antoniop

Rename subsite_callback to comply with OpenACS naming convention, reduce divergency between oracle and postgres codebase

Options
    • -22
    • +0
    ./subsite-callback-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 04 Dec 2001
1:20 am

donb

Switched tree-based queries to a tree-using form, which will greatly enhance

scalability...

Options
    • -1
    • +1
    ./subsite-callback-procs-postgresql.xql
  2. … 26 more files in changeset.
Sunday 22 Jul 2001
7:28 pm

stevew

Port queries

Options
    • -5
    • +5
    ./subsite-callback-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 15 May 2001
6:59 pm

stevew

Port queries/query extractor output

Options
    • -0
    • +22
    ./subsite-callback-procs-postgresql.xql
  2. … 180 more files in changeset.