Re: [GENERAL] good exception handling archiecutre

2010-08-17 Thread Atul.Goel
-general@postgresql.org Subject: Re: [GENERAL] good exception handling archiecutre Heyho! [[ logging from postgres ]] I think you can use dblink to do this - everything you do via dblink happens in a separate db session and so it shouldn't be affected by what happens in your transa

Re: [GENERAL] good exception handling archiecutre

2010-08-17 Thread Atul.Goel
! > -Original Message- > From: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl] > Sent: 13 August 2010 17:50 > To: Atul Goel > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] good exception handling archiecutre > > On 13 Aug 2010, at 14:07, > wrote: > &

Re: [GENERAL] good exception handling archiecutre

2010-08-16 Thread Alban Hertroys
: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl] > Sent: 13 August 2010 17:50 > To: Atul Goel > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] good exception handling archiecutre > > On 13 Aug 2010, at 14:07, > wrote: > >> How can we do er

Re: [GENERAL] good exception handling archiecutre

2010-08-16 Thread Adrian von Bidder
Heyho! [[ logging from postgres ]] I think you can use dblink to do this - everything you do via dblink happens in a separate db session and so it shouldn't be affected by what happens in your transaction. Depending on your requirements, system resources may be an issue though (you're opening

Re: [GENERAL] good exception handling archiecutre

2010-08-16 Thread Atul.Goel
utwente.nl] Sent: 13 August 2010 17:50 To: Atul Goel Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] good exception handling archiecutre On 13 Aug 2010, at 14:07, wrote: > How can we do error logging in Postgres. I am trying to create a LOG_AND_STOP > method which would be generi

Re: [GENERAL] good exception handling archiecutre

2010-08-13 Thread Alban Hertroys
On 13 Aug 2010, at 14:07, wrote: > How can we do error logging in Postgres. I am trying to create a LOG_AND_STOP > method which would be generic to the code. I have pasted the code I have > written. This code returns no data which is understandable as the error is > thrown to the external wo

[GENERAL] good exception handling archiecutre

2010-08-13 Thread Atul.Goel
How can we do error logging in Postgres. I am trying to create a LOG_AND_STOP method which would be generic to the code. I have pasted the code I have written. This code returns no data which is understandable as the error is thrown to the external world. Can I write the code somehow. CREATE S