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

00-database-procs-postgresql.tcl

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 13
Last Commit: 03 Jun
Commits this week: 0
Total Lines of Code (LoC): 19
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
Saturday 22 Dec 2001
10:52 pm

donb

The bindvar emulation for db_exec_plpgsql now calls DoubleApos on the

values ...

Options
    • -3
    • +3
    ./00-database-procs-postgresql.tcl
7:58 pm

donb

Made the datasource "::dbname" function the same as

"localhost::dbname"

Options
    • -2
    • +2
    ./00-database-procs-postgresql.tcl
Saturday 08 Dec 2001
2:17 am

donb

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

Options
    • -2
    • +1
    ./00-database-procs-postgresql.tcl
  2. … 62 more files in changeset.
Wednesday 21 Nov 2001
2:26 am

donb

1. Fixed a boneheaded error in the bootstrapper: "AvailablePool" was being

submitted to a case-sensitive check. Of course AOLserver parameters are

case-insensitive.

2. A recently submitted patch to the db routine that PSQL's source broke

the code if you haven't started postmaster with the "-i" option.

3. Bboard was very, very slow in PG. It is now much faster.

Options
    • -4
    • +12
    ./00-database-procs-postgresql.tcl
  2. … 3 more files in changeset.
Tuesday 20 Nov 2001
10:49 pm

donb

Installed some patches:

1. Request processor was losing the port portion of the URL in some cases.

2. OpenACS 4 couldn't cope with a PG database that was password-protected

3. Didn't work with nsopenssl

Also I removed references to currency.sql from acs-lang (this is now part

of the references package)

Options
    • -3
    • +31
    ./00-database-procs-postgresql.tcl
  2. … 4 more files in changeset.
3:04 am

donb

1. changed db_qd_log to use the passed-in level rather than gluing things

to "Debug" for convenience. I then changed all the "Notice" calls to

"Debug". Then my one "Error" call I added worked! :) If a query file

has a syntax error in it now, an error is logged to the server log but

bootstrapping continues.

2. Lots and lots or etp oracle fixes and some PG version clean-ups

3. Some file-storage files were unconventionally named.

Options
    • -9
    • +9
    ./00-database-procs-postgresql.tcl
  2. … 17 more files in changeset.
Sunday 16 Sep 2001
3:34 pm

donb

Fixed db_blob_get for PG, and got rid of db_continue_transaction, which we

can no longer support because PG automatically aborts a transaction after an

error.

Options
    • -18
    • +4
    ./00-database-procs-postgresql.tcl
  2. … 4 more files in changeset.
Monday 03 Sep 2001
8:17 pm

donb

*** empty log message ***

Options
    • -3
    • +3
    ./00-database-procs-postgresql.tcl
2:03 am

donb

Added a db_api hook to return blob data directly in a Tcl variable, as

requested by Neophytos.

Options
    • -5
    • +60
    ./00-database-procs-postgresql.tcl
Monday 20 Aug 2001
7:15 am

ben

fixed a few more subsite issues, and added a special case to query dispatcher.

Options
    • -2
    • +7
    ./00-database-procs-postgresql.tcl
  2. … 10 more files in changeset.
Sunday 19 Aug 2001
11:26 pm

donb

1. Fixed a bug in the oracle version of acs-mail-nt-create.sql

2. Fixed a bug in the oracle version of the APM - a standard SQL92

left join was being executed rather than the nasty Oracle-specific

notation.

3. Futzed with the APM a bit - you can now only set "watch" commands on

those .xql files which are used by the current installation, you can

only install packages supported by the current installation's RDBMS.

Options
    • -8
    • +1
    ./00-database-procs-postgresql.tcl
  2. … 8 more files in changeset.
Monday 30 Jul 2001
1:16 am

donb

1. Added a check that PG was initdb's with the collation order for

characters that we expect.

2. Jon added a "sql/common" directory for the insert statements which

load data for acs-references, so I added a new datamodel type "common"

to the APM.

3. Created a new db API routine that returns true if a given db_type is

compatible with the current RDBMS.

4. Added a workaround for a PL/pgSQL "execute" bug in acs-workflow (other

cases had been fixed previously by others but this one was missed)

5. Diddled a couple of .info files using the APM.

Options
    • -3
    • +15
    ./00-database-procs-postgresql.tcl
  2. … 10 more files in changeset.
Sunday 22 Jul 2001
5:11 pm

danw

fixed uplevel name collision

Options
    • -4
    • +4
    ./00-database-procs-postgresql.tcl
Thursday 14 Jun 2001
2:30 am

danw

adde switches to prevent error on clobs and blobs

Options
    • -2
    • +2
    ./00-database-procs-postgresql.tcl
Wednesday 30 May 2001
10:53 pm

ben

fixed logging to be more configurable within the QD and default to not so verbose.

Options
    • -10
    • +10
    ./00-database-procs-postgresql.tcl
  2. … 2 more files in changeset.
Tuesday 15 May 2001
7:09 am

danw

more debugging of workflow

Options
    • -2
    • +2
    ./00-database-procs-postgresql.tcl
  2. … 3 more files in changeset.
Thursday 10 May 2001
7:35 pm

stevew

psql doesn't like -U without a username

Options
    • -2
    • +5
    ./00-database-procs-postgresql.tcl
12:32 am

donb

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

Options
    • -11
    • +63
    ./00-database-procs-postgresql.tcl
  2. … 36 more files in changeset.
Wednesday 09 May 2001
7:15 am

danw

tested and fixed the template query db api

Options
    • -7
    • +7
    ./00-database-procs-postgresql.tcl
  2. … 26 more files in changeset.
Sunday 06 May 2001
4:53 pm

danw

added blobs switch to db_dml, so that update statements can be ported to write the content column directly

Options
    • -2
    • +2
    ./00-database-procs-postgresql.tcl
4:30 pm

danw

more cleanup of CR and blob support

Options
    • -16
    • +82
    ./00-database-procs-postgresql.tcl
  2. … 3 more files in changeset.
Friday 04 May 2001
8:04 am

danw

converted apm to store package tarballs in the content repository

Options
    • -1
    • +7
    ./00-database-procs-postgresql.tcl
  2. … 7 more files in changeset.
Thursday 03 May 2001
6:25 am

danw

added comment about db_dml -blob_files change

Options
    • -1
    • +19
    ./00-database-procs-postgresql.tcl
6:00 am

danw

tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

Options
    • -8
    • +26
    ./00-database-procs-postgresql.tcl
  2. … 9 more files in changeset.
Tuesday 01 May 2001
6:37 am

danw

finished porting portrait upload to work with CR

Options
    • -16
    • +36
    ./00-database-procs-postgresql.tcl
  2. … 4 more files in changeset.
Monday 30 Apr 2001
7:33 am

danw

work on protrait upload

Options
    • -6
    • +9
    ./00-database-procs-postgresql.tcl
  2. … 5 more files in changeset.
Wednesday 25 Apr 2001
1:59 am

danw

more query extraction work

Options
    • -10
    • +80
    ./00-database-procs-postgresql.tcl
  2. … 6 more files in changeset.
Friday 20 Apr 2001
4:03 am

danw

added tcl variable support to db api

Options
    • -1
    • +7
    ./00-database-procs-postgresql.tcl
  2. … 3 more files in changeset.
Monday 16 Apr 2001
11:59 pm

ben

updated API of DB QD

Options
    • -6
    • +6
    ./00-database-procs-postgresql.tcl
  2. … 4 more files in changeset.
Friday 13 Apr 2001
9:10 pm

donb

Call to psql to load datamodels needs to be done in the directory that

the datamodel lives in, as includes in psql are resolved relative to

the current working directoy. I missed this earlier - sqlplus resolves

includes relative to the loading .sql file itself.

Options
    • -2
    • +4
    ./00-database-procs-postgresql.tcl