On Fri, Nov 18, 2011 at 14:31, Tigran Mkrtchyan <tigran.mkrtch...@desy.de> wrote: > > On Fri, Nov 18, 2011 at 9:52 PM, Tomas Vondra <t...@fuzzy.cz> wrote:
> > Anyway this definitely is not a bug, > > Still not convinced. You are unlikely to convince anyone here otherwise... Its works that way by design. > [...] I don't think you will be happy of /var/log/messages will be > full of error messages when a user tries to create an existing file. > Well, of course I can check myself the file exists, but why I need DB > transactions if my application have to take care about that. If you don't want them logged you could 'catch' them by creating a wrapper function in plpsql, something like: http://www.postgresql.org/docs/9.1/interactive/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs