package-procs-postgresql.xql

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between oracle and postgres codebase

  1. … 2 more files in changeset.
Reduce divergency between oracle and postgres codebase, reduce query replication using api

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

  1. … 7834 more files in changeset.
- fix for bug #2962

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)

  1. … 1 more file in changeset.
.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)

  1. … 70 more files in changeset.
- remove unneeded xql statements

  1. … 12 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2547 more files in changeset.
- fix dollar escaping as indicated by Tony Kirkham in the OpenACS Development forum

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

  1. … 3 more files in changeset.
Merged 5.5.1 to HEAD

  1. … 181 more files in changeset.
package_exec_plsql didn't work if the sql proc being called has a parameter

named "package_name"...

  1. … 2 more files in changeset.
bugfix: fixing bug #2399, wrong query labeling in xql files

  1. … 1 more file in changeset.
Fixed duplicate package_function_p definitions and miss-named sql.

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

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

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

Made package_exec_plsql work for Oracle procedures ...

  1. … 2 more files in changeset.
Fixed get_pageflow_structure to correctly label the index_redirect_url as

"Home".

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

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

  1. … 3 more files in changeset.
reversing patch 336, cuz it seems not to work. adding a url to the site map breaks.

Patch 336 for Bug 1636 by Dave Bauer

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

scalability...

  1. … 26 more files in changeset.
updated package_instantiate_object for PG

Small fixes

  1. … 3 more files in changeset.
Fix typo in arg name.

Port group-type maintenance (no attributes yet)

    • -21
    • +107
    ./package-procs-postgresql.xql
  1. … 14 more files in changeset.
Port queries

  1. … 2 more files in changeset.
Port queries/query extractor output

    • -10
    • +117
    ./package-procs-postgresql.xql
  1. … 180 more files in changeset.