• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Modified Barry Brooks's context_id update trigger speedup for PostgreSQL,

did some testing ...

  1. … 1 more file in changeset.
add user id and IP address to update_last_modified()

  1. … 10 more files in changeset.
Merged with 4.6 branch

  1. … 30 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 53 more files in changeset.
Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

  1. … 17 more files in changeset.
rollback Dons commit which should have gone in on 4.6 rather than HEAD

  1. … 7 more files in changeset.
More mucking around with the denormalized party_approved_member_map ...

  1. … 7 more files in changeset.
delete direct permissions in acs_object__delete (oracle and postgres) upgrade provided, bug 234 patch 74 Tilmann Singer

  1. … 3 more files in changeset.
1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

  1. … 23 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

  1. … 54 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

  1. … 54 more files in changeset.
fixed a query that used select instead of perform

postgres does not like a certain flavor of table aliases

adding variation on function

forgot to pass last_modified in recursive call

created acs_object.update_last_modified procedure that takes in an object_id

and an optional timestamp and sets the last_modified time of the object and

all of it's parents (not including object 0) to the last_modified time passed

in or sysdate if none was passed in.

  1. … 1 more file in changeset.

Merged with OpenACS 4.5 beta1 branch.

  1. … 88 more files in changeset.

1. Community core change was due to an earlier patch that allows a person

to register as a user.

2. Deleting an acs-object would fail if the object specific table didn't exist.

acs-objects and the content repository shouldn't require type specific tables

be named when you extend a type, this is a temporary hack which acknowledges

that folks have been cheating by name non-existent tables. Since I plan to

remove the restriction anyway, this is not a big deal.

The Oracle version still needs testing ...

  1. … 2 more files in changeset.
fixed an efficiency issue in removing objects

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

  1. … 18 more files in changeset.

Changed the representation of tree_sortkeys from "text" to "bit varying".

  1. … 62 more files in changeset.
made /pvt/home configurable

  1. … 3 more files in changeset.

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

  1. … 11 more files in changeset.
added acs_object__new which takes security_inherit_p as an arguement. Needed for static pages

Install acs-service-contract ...

  1. … 2 more files in changeset.
fixed acs_objects__get_attribute so that it works with all return types. Problems were encountered with returning integer and timestamp types

fixed return type of acs_object__get_attribute so that timestamps can be returned

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

  1. … 23 more files in changeset.
more strict string handling changes

  1. … 4 more files in changeset.
added comments for default api values

  1. … 12 more files in changeset.