• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Ported data models for PostgreSQL. The data model create and drop scripts load without errors. *-sws not ported because it is not loaded by ecommerce-create.sql.

oops, I accidently committed the PostgreSQL version of this file into the Oracle sql directory. This commit is to fix my error.

ported to PostgreSQL, loads without error, not tested in any other way

removed logical_negation because it was already defined in utilities-create.sql in acs-kernel

removed definition of logical_negation because it is already defined in utilities-create.sql in acs-kernel

code cleanup

forgot a -

minor bugfixes

added perms assignment to __new

removed a drop fxn statement

removed aD code

removed aD code

improved comments

re-enabled acs-messaging snippet

Cleaned datamodel (number->numeric)

initial revision

updated with vinods patches

workaround for content_item__delete problem related to pg RI problems

fixed acs_objects__get_attribute so that it works with all return types. Problems were encountered with returning integer and timestamp types

fixed context bar query as suggested by Luke Pond

add tree_sortkey to acs_messages to enable hierarchical queries on the reply_to field

took out the join to the acs_objects table. used acs_object__get_attribute to get the necessary queries.

Porting forms-procs. Not done yet (it's a big one). Committing for historic purposes.

    • -0
    • +173
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -0
    • +165
    /openacs-4/packages/cms/tcl/form-procs-postgresql.xql
    • -0
    • +39
    /openacs-4/packages/cms/tcl/form-procs.xql
Still porting. Not done with this file yet (it's a big

one). Committing for history purposes.

    • -42
    • +19
    /openacs-4/packages/cms/tcl/form-procs.tcl
Working my way through porting.

    • -88
    • +38
    /openacs-4/packages/cms/tcl/form-procs.tcl
Initial Revision.

Initial revision

Ported queries.

    • -0
    • +23
    /openacs-4/packages/cms/tcl/cms-folder-procs-postgresql.xql
fixed return type of acs_object__get_attribute so that timestamps can be returned

changed number to numeric

added call to person.name

Changed [db_nextval sp_session_id_seq] to [db_nextval sp_session_id_sequence] to use the view.