Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated

Hi Adrian, no, system hang and i had to do a power reset (nothing else helped) By system do you mean just Postgres or the computer as a whole? The whole system was hanging (Ubuntu). very strange: did a "lshw" not being root. no idea what was going on. But we don't have to discuss that

Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated

Hi Adrin, Am 11.10.19 um 21:42 schrieb Adrian Klaver: On 10/11/19 10:28 AM, wambac...@posteo.de wrote: Hi, after a crash i get this errpor: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER:  tuple concurrently updated any idea what i can do? More information would be

got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated

Hi, after a crash i get this errpor: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER:  tuple concurrently updated any idea what i can do? regards walter -- My projects: Admin Boundaries of the World Missing Boundaries

Re: logging "raise" to file

Thank Georg, regards walter > the red part writes your "raise notice" to your log > > psql (+your connection string) -f /path/to/file.sql *> > /path/to/log/xxx.log 2>&1* > > -- My projects: Admin Boundaries of the World Missing Boundaries

logging "raise" to file

Hi, is there a way to log output from "raise ..." to a local file? \o file does not work (for me). regards walter -- My projects: Admin Boundaries of the World Missing Boundaries

Re: update table with suppress_redundant_updates_trigger()

Problem "solved". "found" will be true of false depending on the trigger action. update done -> found = true, update not done -> found=false. But: The trigger sometimes allows updates where no data has been changed! That is another problem to be solved :( Regards walter Am 25.02.19 um 19:42

update table with suppress_redundant_updates_trigger()

Hi, i'm doing a lot of updates in my database, but most of them are not necessary at all (sorry, just detected it) Therefore i installed a trigger to minimize real updates. create trigger suppress_redundant_updates_boundaries    before update on boundaries    for each row execute procedure

Re: changing my mail address

thanks, got it. walter Am 17.03.2018 um 16:51 schrieb Stephen Frost: Greetings, * wambac...@posteo.de (wambac...@posteo.de) wrote: how can i change my mail adress for the postgresql mailing lists? adding my new address worked, but how do i get rid of the old one? You'll need to change it

changing my mail address

Hi, how can i change my mail adress for the postgresql mailing lists? adding my new address worked, but how do i get rid of the old one? regards walter