security-procs-postgresql.xql

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

Fixed the 4K character limit on session properties for Oracle by making an

optional "clob" value available. The APM wouldn't let me load any packages

when I added all the dotLRN packages plus standard packages over to a new

"dotlrn" user from my normal "acs" user - the list of packages grew to

> 4KB in size! Grrrr!

  1. … 6 more files in changeset.

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.

  1. … 8 more files in changeset.
query extractor output for acs-tcl

  1. … 41 more files in changeset.

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

  1. … 6 more files in changeset.

1. Removed acs_source (which Ben had already removed, I think he just forgot

to commit)

2. Wrote a PG semi-replacement query for an Oracle query containing "sample()"

  1. … 2 more files in changeset.
new version of QD with better handling of absolute/relative paths

  1. … 10 more files in changeset.
added acs_source to wrap the source command, and changed the QD to recognize scripts called by acs_source

  1. … 5 more files in changeset.
initial import

    • -0
    • +13
    ./security-procs-postgresql.xql