calendar-outlook-procs-postgresql.xql

  • last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
starting to add timezone support to the calendar package. Have not finished this task yet as we are waiting for Dirk to help us fix some major breakages that are preventing us from testing

    • -15
    • +0
    ./calendar-outlook-procs-postgresql.xql
  1. … 26 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -7
    • +7
    ./calendar-outlook-procs-postgresql.xql
  1. … 76 more files in changeset.
A variety of changes that add up to making outlook synchronization work

with PostgreSQL (at all) and Oracle (better).

1. Changed calendar to read SystemTimezone rather than hardwire it to

US/Eastern.

2. Made calendar depend on acs-lang since that's where the param lives.

3. Fixed the query on the acs-lang page that lets you set the timezone

(used the Oracle-ism UNIQUE rather than the standard DISTINCT)

4. Saw that the test stuff doesn't work and got rid of the links on the

index page - people can live without testing it for this release (we

should fix it for 4.7)

5. Fixed timezone__local_to_utc so it works with calendar, though it's

very whacky (shifted so the timezone'd date part is the UTC date, would

be much much better to use timestamp without timezone but PG doesn't

accept that syntax for function returns and we're not ready to drop

PG 7.2 support yet so I can't take advantage of the timestamp/timestamptz

type names, sigh)

    • -7
    • +7
    ./calendar-outlook-procs-postgresql.xql
  1. … 6 more files in changeset.
added outlook PG support

    • -0
    • +15
    ./calendar-outlook-procs-postgresql.xql
  1. … 3 more files in changeset.