Re: Row data is reflected in DETAIL message when constraints fail on insert/update

2019-06-22 Thread William Denton
>I guess the original question basically boils down to "Given a >rogue/dumb app, and a DBA who neglected his job, is it PG's >business (or even within its possibilities) to mop up ?" It feels like you aren't setting people up to land in the pit of success. It's easy to sit back and call people neg

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

2019-06-22 Thread Joe Conway
On 6/22/19 6:00 AM, William Denton wrote: >>I guess the original question basically boils down to "Given a >>rogue/dumb app, and a DBA who neglected his job, is it PG's >>business (or even within its possibilities) to mop up ?" > > It feels like you aren't setting people up to land in the pit of s

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

2019-06-22 Thread Peter J. Holzer
On 2019-06-22 22:00:12 +1200, William Denton wrote: > >I guess the original question basically boils down to "Given a > >rogue/dumb app, and a DBA who neglected his job, is it PG's > >business (or even within its possibilities) to mop up ?" > > It feels like you aren't setting people up to land in

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

2019-06-22 Thread Karsten Hilbert
On Sat, Jun 22, 2019 at 06:40:10PM +0200, Peter J. Holzer wrote: > > How is it useful in a normally configured database to return row data in > > error messages? > > This is extremely useful. It tells you what data didn't match your > program's expectations. Otherwise you just get a vague "unique

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

2019-06-22 Thread Adrian Klaver
On 6/22/19 10:09 AM, Karsten Hilbert wrote: On Sat, Jun 22, 2019 at 06:40:10PM +0200, Peter J. Holzer wrote: How is it useful in a normally configured database to return row data in error messages? This is extremely useful. It tells you what data didn't match your program's expectations. Othe

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

2019-06-22 Thread Peter J. Holzer
On 2019-06-22 19:09:41 +0200, Karsten Hilbert wrote: > On Sat, Jun 22, 2019 at 06:40:10PM +0200, Peter J. Holzer wrote: > > > How is it useful in a normally configured database to return row data in > > > error messages? > > > > This is extremely useful. It tells you what data didn't match your > >

LDAP Search failing when i provide Multiple entry in pg_hba.conf

2019-06-22 Thread Revana Siddu
Hi, This my pg_hba.conf , If I comment one entry users belong that basedn works , With 2 entry not working ... Please help how to go about this hostall all clienthostip/32 ldap ldapserver= ldapserver.com ldapbasedn="OU=Users,OU=AP Region,DC=xx,DC=com" ldapbinddn="cn=se