OpenACS / openacs-4 / packages / acs-subsite / tcl

package-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 234
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 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -98
    • +98
    ./package-procs-postgresql.xql
  2. … 8099 more files in changeset.
Monday 12 Aug 2024
5:35 pm

gustafn

removed calls to deprecated procs

Options
    • -2
    • +2
    ./package-procs-postgresql.xql
Tuesday 14 Sep 2021
8:01 pm

gustafn

whitespace changes

Options
    • -96
    • +96
    ./package-procs-postgresql.xql
  2. … 1 more file in changeset.
Thursday 14 Jun 2018
5:05 pm

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -11
    • +0
    ./package-procs-postgresql.xql
  2. … 2 more files in changeset.
Monday 20 Nov 2017
4:19 pm

antoniop

Reduce divergency between oracle and postgres codebase, reduce query replication using api

Options
    • -8
    • +1
    ./package-procs-postgresql.xql
  2. … 3 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -48
    • +12
    ./package-procs-postgresql.xql
  2. … 7834 more files in changeset.
Monday 13 Jun 2016
1:11 pm

gustafn

- fix for bug #2962

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
9:44 am

gustafn

Bugfix: not possible to define group types over admin interface:

- Remove dependency on "user_objects" in PostgreSQL code: This table

is an interface to Oracle's data dictionary and gives access to all

defined objects (tables, views, functions, packages, ...) and is

used to check, whether code has to be recompiled after some update.

This code check is now deactivated for PostgreSQL for the time

being.

- Without this change, it was not possible to define group

types in postgres over the admin interface (in acs-subsite)

Options
    • -7
    • +7
    ./package-procs-postgresql.xql
  2. … 1 more file in changeset.
Wednesday 28 Oct 2015
10:38 am

gustafn

.xql overhaul:

- removed misleading sql-statements from db_* calls, which were

ignored due .xql files

- removed bug where same query name was used in a single proc

with different intended sql queries, but the same was picked

up from the .xql file due to the name

- removed multiple entries of same query name from .xql files

(e.g. the entry "package_create_attribute_list.select_type_info" was

7 (!!!) times in a single .xql file)

- removed redundant queries for unsupported versions of the dbms

- added missing xql entries for db-backends, where other db-specific

queries exists (e.g. added an entry to -oracle.xql, where an entry

existed in -postgres.xql)

Options
    • -26
    • +4
    ./package-procs-postgresql.xql
  2. … 70 more files in changeset.
Tuesday 27 Oct 2015
11:56 pm

gustafn

- remove unneeded xql statements

Options
    • -14
    • +0
    ./package-procs-postgresql.xql
  2. … 12 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
    • -4
    • +4
    ./package-procs-postgresql.xql
  2. … 2547 more files in changeset.
Saturday 02 Aug 2014
12:05 pm

gustafn

- fix dollar escaping as indicated by Tony Kirkham in the OpenACS Development forum

Options
    • -4
    • +4
    ./package-procs-postgresql.xql
Saturday 30 Mar 2013
8:32 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -11
    • +13
    ./package-procs-postgresql.xql
  2. … 3 more files in changeset.
Monday 14 Sep 2009
1:54 am

donb

Merged 5.5.1 to HEAD

Options
    • -3
    • +2
    ./package-procs-postgresql.xql
  2. … 181 more files in changeset.
Tuesday 11 Aug 2009
1:40 am

donb

package_exec_plsql didn't work if the sql proc being called has a parameter

named "package_name"...

Options
    • -3
    • +2
    ./package-procs-postgresql.xql
  2. … 2 more files in changeset.
Friday 15 Apr 2005
6:31 pm

timoh

bugfix: fixing bug #2399, wrong query labeling in xql files

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
  2. … 1 more file in changeset.
Tuesday 18 Jan 2005
1:13 pm

leed

Fixed duplicate package_function_p definitions and miss-named sql.

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
  2. … 1 more file in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -1
    • +7
    ./package-procs-postgresql.xql
  2. … 2275 more files in changeset.
Saturday 25 Dec 2004
10:33 pm

donb

Fixed package_exec_plsql so it works with Oracle procedures as well as

functions (PG only has functions so was working fine for all cases)

Options
    • -1
    • +7
    ./package-procs-postgresql.xql
  2. … 2 more files in changeset.
Monday 28 Jun 2004
8:34 am

jeffd

revert the 1.12 - 1.13 change, breaks adding group types and rel types (and other autogenerated plpgsql) http://openacs.org/forums/message-view?message_id=190202, bug 1893

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
Sunday 06 Jun 2004
4:28 am

donb

Made package_exec_plsql work for Oracle procedures ...

Options
    • -4
    • +10
    ./package-procs-postgresql.xql
  2. … 2 more files in changeset.
Wednesday 17 Mar 2004
1:22 am

donb

Fixed get_pageflow_structure to correctly label the index_redirect_url as

"Home".

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
  2. … 2 more files in changeset.
Thursday 15 Jan 2004
3:42 am

donb

Fixed new package_exec_lsql proc and also fixed bug involving funcs which

have parameters named "key" etc by renaming internal vars "__key" etc as

needed ...

Options
    • -2
    • +2
    ./package-procs-postgresql.xql
  2. … 2 more files in changeset.
Saturday 03 Jan 2004
2:44 am

donb

Added "package_exec_plsql" which, like "package_instantiate_object", allows

one to call PLSQL from Tcl, which reduces the need for oracle/pg-specific

XQL files.

Options
    • -1
    • +12
    ./package-procs-postgresql.xql
  2. … 3 more files in changeset.
Sunday 18 Aug 2002
1:08 am

vinodk

reversing patch 336, cuz it seems not to work. adding a url to the site map breaks.

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
Saturday 17 Aug 2002
8:05 pm

vinodk

Patch 336 for Bug 1636 by Dave Bauer

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
Tuesday 04 Dec 2001
1:20 am

donb

Switched tree-based queries to a tree-using form, which will greatly enhance

scalability...

Options
    • -13
    • +8
    ./package-procs-postgresql.xql
  2. … 26 more files in changeset.
Tuesday 27 Nov 2001
7:08 am

ben

updated package_instantiate_object for PG

Options
    • -0
    • +8
    ./package-procs-postgresql.xql
Sunday 09 Sep 2001
6:34 pm

stevew

Small fixes

Options
    • -1
    • +1
    ./package-procs-postgresql.xql
  2. … 3 more files in changeset.
Sunday 12 Aug 2001
11:11 pm

stevew

Fix typo in arg name.

Options
    • -1
    • +1
    ./package-procs-postgresql.xql