|
From: Lukas R. <Luk...@lp...> - 2018-01-29 00:00:57
|
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 |