From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | Scott Whitney <scott(at)journyx(dot)com> |
Cc: | "Scott Ribe" <scott_ribe(at)elevated-dev(dot)com>, "Rossi\, Maria" <maria(dot)rossi(at)us(dot)pgds(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Suppress 'duplicate key' at errorlog? |
Date: | 2015-03-31 00:54:27 |
Message-ID: | 86oana3s1o.fsf@jerry.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Scott Whitney <scott(at)journyx(dot)com> writes:
> Am I the only one concerned about a product trying to duplicate a pkey? This is not usually the LAST step. It's early on in the logical process. You have to find and
> solve the underlying cause.
I've seen lazy developers use a try insert/update if fail to implement a
poor man's upsert... a feature much sought after and only now being
seriously developed for Postgres.
So... whether or not it's a bug is application dependent.
Yes I'd question a 3rd party about this if the product wasn't developed
in house and/or fully open to code review to have them tell me "we did
it that way on purpose" though rather than just declaring it a nuisance.
FWIW
> On Mon, Mar 30, 2015 at 6:17 PM, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
>
> On Mar 30, 2015, at 3:03 PM, Rossi, Maria <maria(dot)rossi(at)us(dot)pgds(dot)com> wrote:
> >
> > Hi,
> >
> > Is there a way to suppress a âduplicate keyâ msg from the errorlog? Due to a bug in a 3rd party application, this keeps on appearing and I am concerned that it
> will fill up the filesystem. I can delete the old errorlog, but if there is any other meaningful msgs out there, I would lose that too.
>
> No way to turn off that specific error message, but you could filter them out of the log, being careful of course not to filter any messages which might be more
> meaningful. You could also prevent the errors from being raised by using a trigger, but I don't like that idea very much at all.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> https://www.linkedin.com/in/scottribe/
> (303) 722-0567 voice
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | jesse.waters | 2015-03-31 12:47:49 | Permission select pg_stat_replication |
Previous Message | Scott Whitney | 2015-03-31 00:12:48 | Re: Suppress 'duplicate key' at errorlog? |