OpenACS / openacs-4 / packages / acs-content-repository / sql / postgresql

content-keyword.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 452
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -7
    • +2
    ./content-keyword.sql
  2. … 2547 more files in changeset.
Thursday 07 Jul 2011
12:46 pm

gustafn

Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

Options
    • -117
    • +207
    ./content-keyword.sql
  2. … 54 more files in changeset.
Sunday 20 Mar 2005
2:41 pm

daveb

Add content_keyword__del to match oracle pl/sql.

Add define_function_args calls for content-keyword.sql.

Add basic tests for content::keyword apis.

Options
    • -42
    • +21
    ./content-keyword.sql
  2. … 4 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -2
    • +41
    ./content-keyword.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -41
    • +2
    ./content-keyword.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -2
    • +41
    ./content-keyword.sql
  2. … 96 more files in changeset.
Tuesday 17 Feb 2004
4:32 pm

donb

PG 7.3 doesn't support 'current_timestamp' as a literal any more (it still

is defined as a variable, of course). Also define_function_args assumes

NULL as the default value if none is specified, 'null' <> NULL ...

Options
    • -1
    • +1
    ./content-keyword.sql
  2. … 6 more files in changeset.
Friday 06 Feb 2004
9:02 pm

donb

Added define_function_arg calls to non-content-revision objects and to

create_type and create_attributes, so we can do these operations via

Tcl. Content revisions, due to LOB/non-LOB issues and the incompatibility

of LOB operations between DBs need their own "smart" Tcl API.

Options
    • -0
    • +3
    ./content-keyword.sql
  2. … 10 more files in changeset.
Monday 26 Jan 2004
4:39 pm

jeffd

merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

Options
    • -4
    • +7
    ./content-keyword.sql
  2. … 286 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -15
    • +55
    ./content-keyword.sql
  2. … 598 more files in changeset.
Saturday 17 May 2003
11:35 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +1
    ./content-keyword.sql
  2. … 101 more files in changeset.
Thursday 27 Feb 2003
2:55 pm

lars

Fixed typo (extra parenthesis) in content_keyword__is_assigned

Options
    • -22
    • +2
    ./content-keyword.sql
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -1
    • +1
    ./content-keyword.sql
  2. … 54 more files in changeset.
Saturday 30 Nov 2002
6:11 pm

jeffd

merge from oacs-4-6

Options
    • -2
    • +1
    ./content-keyword.sql
  2. … 110 more files in changeset.
Sunday 09 Dec 2001
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
    • -2
    • +0
    ./content-keyword.sql
  2. … 18 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

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

Options
    • -41
    • +23
    ./content-keyword.sql
  2. … 62 more files in changeset.
Friday 08 Jun 2001
3:52 am

danw

fixed a few pl/sql procs

Options
    • -3
    • +3
    ./content-keyword.sql
  2. … 2 more files in changeset.
Saturday 28 Apr 2001
9:58 pm

donb

Removed more of the "default '' not null" kludge.

Options
    • -1
    • +1
    ./content-keyword.sql
  2. … 18 more files in changeset.
Thursday 19 Apr 2001
1:27 am

danw

added comments for default parameters

Options
    • -11
    • +11
    ./content-keyword.sql
  2. … 10 more files in changeset.
Monday 02 Apr 2001
7:35 am

danw

partial work on content-test

Options
    • -29
    • +7
    ./content-keyword.sql
  2. … 10 more files in changeset.
Friday 30 Mar 2001
5:03 am

danw

added tree queries

Options
    • -15
    • +58
    ./content-keyword.sql
  2. … 6 more files in changeset.
Thursday 29 Mar 2001
3:21 am

danw

more cleanup, added lob support for cr_revisions

Options
    • -1
    • +1
    ./content-keyword.sql
  2. … 9 more files in changeset.
Wednesday 28 Mar 2001
4:15 am

danw

general cleanup of initial porting effort

Options
    • -1
    • +1
    ./content-keyword.sql
  2. … 11 more files in changeset.
Monday 26 Mar 2001
12:47 am

danw

initial port to postgresql

Options
    • -0
    • +323
    ./content-keyword.sql