OpenACS / openacs-4 / packages / acs-kernel / sql / postgresql

acs-relationships-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 13 Nov
Commits this week: 0
Total Lines of Code (LoC): 697
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 01 Nov 2018
9:38 am

gustafn

improve comments and spelling

Options
    • -2
    • +2
    ./acs-relationships-create.sql
  2. … 4 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -26
    • +58
    ./acs-relationships-create.sql
  2. … 7834 more files in changeset.
Wednesday 31 Aug 2016
8:57 pm

gustafn

composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

Options
    • -19
    • +55
    ./acs-relationships-create.sql
  2. … 34 more files in changeset.
Friday 01 Jul 2016
10:57 am

gustafn

Remove type discrepancy introduced in 2002:

- acs_object_types.object_type has type varchar(1000), while

- acs_object_types.supertype has type varchar(100)

... several more data types are involved, using acs_object_types.object_type as foreign key

Options
    • -4
    • +4
    ./acs-relationships-create.sql
  2. … 5 more files in changeset.
Saturday 11 Jun 2016
10:44 am

gustafn

- regenerated documentation to fix escaping problem for message keys

in "programlisting": inserting a ­ after the first hash

Options
    • -5
    • +1
    ./acs-relationships-create.sql
  2. … 121 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
    • -109
    • +204
    ./acs-relationships-create.sql
  2. … 54 more files in changeset.
Wednesday 10 Mar 2010
1:44 am

donb

1. Changed trigger functions from "opaque" to "trigger" to get rid of the

warnings during initial install (only for acs-kernel, there are a lot

elsewhere!)

2. Added "embeds" for postgresql and partially for oracle.

3. Added global parameters for postgresql and partially for oracle.

(oracle will be forthcoming shortly)

Options
    • -2
    • +2
    ./acs-relationships-create.sql
  2. … 29 more files in changeset.
Wednesday 06 Jan 2010
9:07 pm

ryang

add three column constraint to acs_data_links

Options
    • -5
    • +4
    ./acs-relationships-create.sql
  2. … 3 more files in changeset.
Tuesday 05 Jan 2010
4:30 pm

ryang

drop acs_data_links unique constraint, use unique index instead.

Options
    • -4
    • +6
    ./acs-relationships-create.sql
  2. … 3 more files in changeset.
Monday 04 Jan 2010
8:54 pm

ryang

TIP #138 - Add relation_tag to acs_data_links

Options
    • -3
    • +4
    ./acs-relationships-create.sql
  2. … 7 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -4
    • +1
    ./acs-relationships-create.sql
  2. … 283 more files in changeset.
Tuesday 29 Apr 2008
11:00 pm

donb

Removed lock table kludge used to work around PG 7 deadlock

Options
    • -3
    • +1
    ./acs-relationships-create.sql
  2. … 1 more file in changeset.
10:58 pm

donb

Removed lock table that's was a workaround for PG 7x, no longer supported

Options
    • -5
    • +1
    ./acs-relationships-create.sql
Monday 19 Feb 2007
11:15 pm

michaels

define args for acs_rel__delete

Options
    • -1
    • +2
    ./acs-relationships-create.sql
Thursday 16 Nov 2006
12:58 pm

maltes

Fix for deadlock condition (or so Gustav and I hope)

Options
    • -2
    • +5
    ./acs-relationships-create.sql
  2. … 2 more files in changeset.
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -11
    • +11
    ./acs-relationships-create.sql
  2. … 13 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -1
    • +27
    ./acs-relationships-create.sql
  2. … 721 more files in changeset.
Wednesday 14 Dec 2005
11:11 pm

timoh

added new seperate table for application_data_links

Options
    • -1
    • +27
    ./acs-relationships-create.sql
  2. … 3 more files in changeset.
Monday 24 Oct 2005
6:58 pm

eduardop

reverting timoh's "added types application link and application data link" until someone can explainme why it was left broken (Closes: #2663)

Options
    • -35
    • +1
    ./acs-relationships-create.sql
Wednesday 12 Oct 2005
8:23 pm

timoh

removed application data links

Options
    • -18
    • +1
    ./acs-relationships-create.sql
  2. … 1 more file in changeset.
7:57 pm

timoh

fixing broken kernal because of application link depending on apm_packages

Options
    • -18
    • +1
    ./acs-relationships-create.sql
  2. … 1 more file in changeset.
12:05 pm

timoh

added types application link and application data link

Options
    • -1
    • +35
    ./acs-relationships-create.sql
11:57 am

timoh

added application links and application data links registration

Options
    • -1
    • +35
    ./acs-relationships-create.sql
Friday 23 Sep 2005
11:40 am

josee

adding missing line:

select define_function_args('acs_rel__new','rel_id,rel_type,object_id_one,object_id_two,context_id,creation_user,creation_ip');

Options
    • -1
    • +3
    ./acs-relationships-create.sql
Thursday 22 Sep 2005
6:40 pm

josee

adding missing line:

select define_function_args('acs_rel__new','rel_id,rel_type,object_id_one,object_id_two,context_id,creation_user,creation_ip');

Options
    • -1
    • +3
    ./acs-relationships-create.sql
Sunday 27 Feb 2005
2:21 am

donb

A variety of group oriented things, and finally added the definitions of

acs-objects package procs in PG so that we can use package_instantiate_object

and package_db_exec with them.

Options
    • -3
    • +6
    ./acs-relationships-create.sql
  2. … 10 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./acs-relationships-create.sql
  2. … 32 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

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

Options
    • -1
    • +4
    ./acs-relationships-create.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
    • -4
    • +1
    ./acs-relationships-create.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
    • -1
    • +4
    ./acs-relationships-create.sql
  2. … 96 more files in changeset.