Mailing List Archive

Dear all

I need to delete one particular entry from the davical databases directly.

Can you provide any hints/pointers to me how I can achieve that? 

The following entry must be deleted such that all references and
dependencies on that particular entry are correctly removed too:

davical=# select user_no,dav_etag,weak_etag,caldav_data from caldav_data
where dav_etag = 'a46df36d44bc12fa39f5ce2252ed7d1e';
 user_no |             dav_etag             | weak_etag
|                        caldav_data
---------+----------------------------------+-----------+-----------------------------------------------------------
    1024 | a46df36d44bc12fa39f5ce2252ed7d1e |           |
BEGIN:VCALENDAR\r                                        +
         |                                  |           |
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN\r+
         |                                  |           |
VERSION:2.0\r                                            +
         |                                  |           |
BEGIN:VTIMEZONE\r                                        +
         |                                  |           |
TZID:Europe/Berlin\r                                     +
         |                                  |           |
BEGIN:DAYLIGHT\r                                         +
         |                                  |           |
TZOFFSETFROM:+0100\r                                     +
         |                                  |           |
TZOFFSETTO:+0200\r                                       +
         |                                  |           |
TZNAME:CEST\r                                            +
         |                                  |           |
DTSTART:19700329T020000\r                                +
         |                                  |           |
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3\r                 +
         |                                  |           |
END:DAYLIGHT\r                                           +
         |                                  |           |
BEGIN:STANDARD\r                                         +
         |                                  |           |
TZOFFSETFROM:+0200\r                                     +
         |                                  |           |
TZOFFSETTO:+0100\r                                       +
         |                                  |           |
TZNAME:CET\r                                             +
         |                                  |           |
DTSTART:19701025T030000\r                                +
         |                                  |           |
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10\r                +
         |                                  |           |
END:STANDARD\r                                           +
         |                                  |           |
END:VTIMEZONE\r                                          +
         |                                  |           |
BEGIN:VEVENT\r                                           +
         |                                  |           |
CREATED:20170913T201915Z\r                               +
         |                                  |           |
LAST-MODIFIED:20170913T201935Z\r                         +
         |                                  |           |
DTSTAMP:20170913T201935Z\r                               +
         |                                  |           |
UID:6d38a633-c5db-4976-a323-cd27eb508c79\r               +
         |                                  |           | SUMMARY:out of
office\r                                  +
         |                                  |           |
DTSTART;TZID=Europe/Berlin:20170914T070000\r             +
         |                                  |           |
DTEND;TZID=Europe/Berlin:20170914T103000\r               +
         |                                  |           |
TRANSP:OPAQUE\r                                          +
         |                                  |           |
END:VEVENT\r                                             +
         |                                  |           |
END:VCALENDAR\r                                          +
         |                                  |           |


Thank you in advance for any support.

Best regards
Lukas