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

acs-metadata-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 13 Nov
Commits this week: 0
Total Lines of Code (LoC): 1,232
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 04 Jul 2018
7:16 pm

antoniop

Change database type for boolean from "bool" to "boolean" in acs_datatypes

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

gustafn

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

Options
    • -7
    • +7
    ./acs-metadata-create.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
5:59 pm

gustafn

Fix spelling errors

Options
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 48 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
    • -5
    • +5
    ./acs-metadata-create.sql
  2. … 5 more files in changeset.
Wednesday 29 Jul 2015
4:09 am

gustafn

- remove commented out command

Options
    • -6
    • +2
    ./acs-metadata-create.sql
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
    • -2
    • +2
    ./acs-metadata-create.sql
  2. … 2547 more files in changeset.
Thursday 03 Jul 2014
1:57 pm

victorg

Fixing bug 3223

Options
    • -2
    • +2
    ./acs-metadata-create.sql
  2. … 3 more files in changeset.
Monday 01 Aug 2011
1:11 am

donb

Merged oacs-5-7 to HEAD

Options
    • -2
    • +1
    ./acs-metadata-create.sql
  2. … 167 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
    • -219
    • +353
    ./acs-metadata-create.sql
  2. … 54 more files in changeset.
Monday 30 May 2011
10:51 am

victorg

Backporting following fixes:

http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Agustafn%3A20110526040737

http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20110530083105

Options
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
Thursday 26 May 2011
6:07 am

gustafn

- Added comments to function arguments 'create_table_p' and 'dynamic_p'

- Update script for 5.7.0d10 was called

postgresql/upgrade/upgrade-5.7.0d9-upgrade-5.7.0d10.sql

instead of

postgresql/upgrade/upgrade-5.7.0d9-5.7.0d10.sql

so it was never executed. Added the content of d9-d10 to d10-d11.

Options
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
Sunday 24 Apr 2011
11:28 pm

donb

1. Added "--default foo" style comments to new PL/pgSQL function parameters

because xotcl-core, rather than use the metadata created by define_function_params,

ASSIGNS SEMANTICS TO THESE SQL COMMENTS. Bah. If I truly cared about quality

I'd insist the xotcl people fix their code and do things right, but I know that

would never happen so ... kludge away.

2. xotcl-core adds CR attributes (rather than fix core). So my fixing of

core conflicts, meaning I have to kludge again. Still needs to be fixed

for oracle.

Options
    • -8
    • +8
    ./acs-metadata-create.sql
  2. … 3 more files in changeset.
Monday 07 Mar 2011
3:52 am

donb

Fixing many bugs

Options
    • -8
    • +9
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
2:39 am

donb

Had to remove the cascade_p feature of the new drop_type procedure, because

implementing it in Oracle would require a huge reorganization of the order

of definition of object and metadata tables and their associated tables,

which just is not going to happen.

Options
    • -19
    • +5
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
Saturday 05 Mar 2011
11:35 pm

donb

*** empty log message ***

Options
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 1 more file in changeset.
2:47 am

donb

Further bug fixing ... hopefully, testing with AOM will tell the tale.

Also bumped *info file.

Options
    • -3
    • +7
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
2:31 am

donb

Fixed a bug with the new version of create_type, found as I was porting to

Oracle (there *is* a use for Oracle, I'll be damned!).

Options
    • -2
    • +2
    ./acs-metadata-create.sql
  2. … 1 more file in changeset.
Saturday 26 Feb 2011
7:20 pm

donb

Believe it or not, "create_type" has never, ever checked to see if the

given supertype is a valid type. The code now verifies that the given

supertype is a child of "acs_object", except when supertype is passed in

as NULL or '' (in which case it's set to acs_object). Only did it for

PostgreSQL since it's been around forever and whatever Oracle users don't

know, won't hurt them.

Options
    • -1
    • +5
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
Sunday 20 Feb 2011
1:34 am

donb

Moved table building and column adding code from content repository to

kernel, so all objects can benefit. Part of the acs object management package

work.

Options
    • -159
    • +493
    ./acs-metadata-create.sql
  2. … 5 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
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 29 more files in changeset.
Friday 26 Jun 2009
2:38 am

donb

Someone didn't realize that "foo;null" in define_function_args calls sets the

default value to 'null' not NULL...this has been there a long time ... maybe

even my fault, but I don't remember, it's ancient!

Options
    • -3
    • +3
    ./acs-metadata-create.sql
  2. … 1 more file in changeset.
Tuesday 25 Nov 2008
6:08 pm

donb

Preliminary version of "extend package" code, along with new package

attributes that allow the declaration of packages that are subsites.

Options
    • -1
    • +5
    ./acs-metadata-create.sql
  2. … 29 more files in changeset.
Monday 17 Sep 2007
11:43 am

gustafn

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

Options
    • -4
    • +4
    ./acs-metadata-create.sql
  2. … 9 more files in changeset.
Saturday 15 Sep 2007
8:17 pm

gustafn

adding missing function args, fixing incorrect function args, including upgrade script

Options
    • -4
    • +6
    ./acs-metadata-create.sql
  2. … 3 more files in changeset.
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -6
    • +6
    ./acs-metadata-create.sql
  2. … 13 more files in changeset.
Sunday 24 Sep 2006
1:45 pm

maltes

Made sure drop_type__cascade_p parameter has a meaning which is to drop all the objects of a certain type when dropping the object_tpye. Note that this does not work for content_types. Use the according procedure there. Not written in Oracle as there might be a reason for not using the __cascade_p parameter and then I don't want to have done the work of porting to Oracle for nothing

Options
    • -2
    • +11
    ./acs-metadata-create.sql
  2. … 1 more file 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
    • -3
    • +2
    ./acs-metadata-create.sql
  2. … 721 more files in changeset.
Tuesday 28 Mar 2006
1:58 am

donb

1. Copy site template when cloning a community

2. Updated a bunch of dependency files

Options
    • -2
    • +2
    ./acs-metadata-create.sql
  2. … 32 more files in changeset.
Sunday 12 Mar 2006
12:01 am

donb

Added db cache size parameter

Options
    • -12
    • +11
    ./acs-metadata-create.sql
  2. … 2 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./acs-metadata-create.sql
  2. … 32 more files in changeset.