acs-relationships-create.sql

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
improve comments and spelling

  1. … 4 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
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

  1. … 34 more files in changeset.
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

  1. … 5 more files in changeset.
- regenerated documentation to fix escaping problem for message keys

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

  1. … 121 more files in changeset.
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

    • -109
    • +204
    ./acs-relationships-create.sql
  1. … 54 more files in changeset.
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)

  1. … 29 more files in changeset.
add three column constraint to acs_data_links

  1. … 3 more files in changeset.
drop acs_data_links unique constraint, use unique index instead.

  1. … 3 more files in changeset.
TIP #138 - Add relation_tag to acs_data_links

  1. … 7 more files in changeset.
Merged from 5.4.2

  1. … 283 more files in changeset.
Removed lock table kludge used to work around PG 7 deadlock

  1. … 1 more file in changeset.
Removed lock table that's was a workaround for PG 7x, no longer supported

define args for acs_rel__delete

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

  1. … 2 more files in changeset.
Correction of name constraint

  1. … 13 more files in changeset.
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?

  1. … 721 more files in changeset.
added new seperate table for application_data_links

  1. … 3 more files in changeset.
reverting timoh's "added types application link and application data link" until someone can explainme why it was left broken (Closes: #2663)

removed application data links

  1. … 1 more file in changeset.
fixing broken kernal because of application link depending on apm_packages

  1. … 1 more file in changeset.
added types application link and application data link

added application links and application data links registration

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');

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');

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.

  1. … 10 more files in changeset.
fix the static cvs-id tags

  1. … 32 more files in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

  1. … 97 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

  1. … 96 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 more files in changeset.