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

postgresql.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 998
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
Monday 17 Dec 2018
10:13 am

michaela

[PostgreSQL 11] Change 'with (iscachable)' to IMMUTABLE for PG11

Options
    • -1
    • +1
    ./postgresql.sql
Tuesday 01 May 2018
12:43 pm

gustafn

Replace obsolete function bitfromint4() by cast

Options
    • -3
    • +3
    ./postgresql.sql
  2. … 2 more files in changeset.
Monday 30 Apr 2018
4:02 pm

gustafn

Replace obsolete funktion bittoint4() by cast

Options
    • -4
    • +4
    ./postgresql.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
    • -44
    • +17
    ./postgresql.sql
  2. … 7834 more files in changeset.
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
    • -1
    • +2
    ./postgresql.sql
  2. … 2547 more files in changeset.
Wednesday 29 May 2013
11:41 am

victorg

on pg version 9.0 ( and lower ) the function string_to_array takes only two parameters.

Options
    • -1
    • +1
    ./postgresql.sql
  2. … 1 more file in changeset.
Tuesday 23 Apr 2013
5:23 pm

victorg

Creating recursive version of permissions functions iff pg version is >= 8.4.

Options
    • -0
    • +49
    ./postgresql.sql
  2. … 3 more files in changeset.
Tuesday 02 Apr 2013
11:35 am

gustafn

- fix collateral damage

Options
    • -4
    • +4
    ./postgresql.sql
Sunday 31 Mar 2013
2:02 pm

gustafn

- add more cases of $$ quoting

Options
    • -10
    • +12
    ./postgresql.sql
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
    • -212
    • +382
    ./postgresql.sql
  2. … 54 more files in changeset.
Wednesday 22 Jul 2009
1:39 am

donb

Some very archaic PG code that was only working because of weak type checking

in earlier versions. Uncovered by playing with the subsite admin object type

code.

Options
    • -4
    • +4
    ./postgresql.sql
Saturday 20 Sep 2008
1:39 pm

gustafn

- drop_package('...') complain in new versions that it can't drop

some stored procedures. Adding therefore a CASCADE to

the get_func_drop_command().

Options
    • -1
    • +1
    ./postgresql.sql
Sunday 06 Jul 2008
2:08 pm

donb

Fixed type mismatch problem due to tightened up PG 8.3 semantics.

Options
    • -1
    • +1
    ./postgresql.sql
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
    • -24
    • +24
    ./postgresql.sql
  2. … 721 more files in changeset.
Tuesday 22 Mar 2005
6:53 am

gabrielb

Fixes bug #2300.

Options
    • -5
    • +5
    ./postgresql.sql
Sunday 06 Mar 2005
8:09 pm

jeffd

add an explicit cast of proname in drop_package needed in pg8

Options
    • -1
    • +1
    ./postgresql.sql
  2. … 2 more files in changeset.
Saturday 24 Jul 2004
4:44 pm

jeffd

fix some bugs which break things in pg7.5; mostly syntax errors in existing procs.

Options
    • -5
    • +5
    ./postgresql.sql
  2. … 4 more files in changeset.
Wednesday 17 Mar 2004
4:29 pm

jeffd

trim function name and args in define_function_args to avoid difficult to track down problems when calling package_plsql_exec et al

Options
    • -10
    • +10
    ./postgresql.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

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

Options
    • -71
    • +39
    ./postgresql.sql
  2. … 598 more files in changeset.
Sunday 09 Nov 2003
1:51 pm

jeffd

casts in tree_left and tree_right (pg 7.4 needs them it seems), bump version to 5.0a5, upgrade script provided

Options
    • -4
    • +4
    ./postgresql.sql
  2. … 2 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -131
    • +31
    ./postgresql.sql
  2. … 30 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -1
    • +77
    ./postgresql.sql
  2. … 54 more files in changeset.
Wednesday 10 Jul 2002
12:34 am

jeffd

Fix user_tab_comments view so it works on 7.2 (adds objsubid = 0)

Options
    • -8
    • +35
    ./postgresql.sql
Tuesday 25 Jun 2002
12:17 am

yon

added tree_increment_key() function

Options
    • -0
    • +15
    ./postgresql.sql
Wednesday 15 May 2002
5:37 pm

neophytosd

PG-7.2.1 returns false for 0<2^7. strange indeed. 2^7>0 returns true

Options
    • -1
    • +1
    ./postgresql.sql
Friday 22 Feb 2002
9:53 pm

donb

Minor typo, another apostrophe catastrophe.

Options
    • -1
    • +1
    ./postgresql.sql
6:13 pm

donb

Added "iscachable" to "tree_ancestor_p".

Options
    • -4
    • +4
    ./postgresql.sql
Thursday 03 Jan 2002
9:47 pm

donb

Moved from 7/15 bit keys to 7/31 bit keys to accomodate big flat trees.

Options
    • -16
    • +24
    ./postgresql.sql
Sunday 30 Dec 2001
3:52 pm

danw

fixed instr for searching backwards

Options
    • -2
    • +2
    ./postgresql.sql
Wednesday 19 Dec 2001
7:33 pm

donb

Renamed a column named "timestamp" in the security package because this is

now a reserved word in PG (correctly). I changed the Oracle version, too,

because I know that 9i has added the "timestamp" datatype and even if it

will accept it as a column name it's confusing.

I also changes postgresql.sql to load correctly under PG 7.1 and 7.2.

Options
    • -0
    • +1
    ./postgresql.sql
  2. … 8 more files in changeset.