11 Commits

Author SHA1 Message Date
Andrew Ruthven
15d01c8bed Store DTSTART and DTEND from user in shadow columns
We want to store the calculated dtstart and dtend in the database so we can
use SQL to fetch records. However, we also need what the user sent us so we
can allow prop-filters to be used as well.

So we store what the user sends us in dtstart_orig and dtend_orig and only
use for relevant prop-filter reports.
2023-03-12 20:17:43 +01:00
Andrew Ruthven
6819d6d7d1 Add a primary_key to the addressbook_addresses_* tables
This is part of the fix for #276.
2023-02-15 07:42:34 +00:00
Jamie McClymont
0c006b5c7c Make the recurrence range columns in the database tz-aware 2019-01-03 16:04:28 +13:00
Andrew Ruthven
b0a1c9212d Ignore the PostgreSQL version for tests
This just creates bogus test result diffs.
2018-11-12 17:59:51 +13:00
Florian Schlichting
39001794a3 Update caldav_functions.sql for Postgresql 10
From version 10, Postgresql does not allow set-returning functions in
CASE statements. As we're using the functions recursively, we cannot
use LATERAL as suggested in the error message, but we can switch the
condition inside-out with only a limited amount of repetition.
2017-10-04 22:36:29 +02:00
Florian Schlichting
b1ae485973 document the setup that will get regression-suite to pass
The other suites don't pass for me at the moment.
2016-12-01 20:29:28 +01:00
Andrew McMillan
1ab66a70b5 Some database changes for server-side attendee handling. 2016-06-22 23:44:10 +01:00
Florian Schlichting
0b1ab8dc65 document testing setup 2014-10-02 02:01:16 +02:00
Andrew McMillan
62b6921c5d Switch to PostgreSQL 9.1 for my development environment. 2011-11-26 23:19:34 +13:00
Andrew McMillan
c41f4071e4 Get rid of unsightly error due to removal of time_zone table. 2011-09-30 11:56:35 +02:00
Andrew McMillan
6679e31862 Rename test result without spaces. 2011-09-27 12:12:22 +13:00