[GENERAL] Writing XML files to Operating System

Hi All, We are a data based company and are migrating from Oracle to Postgresql. For this purpose I am doing POC for the same. We have a business requirement to send the Data in XML files to our clients. The file size of XMLs is around 700MB and is growing. I have been able to generate sample

Re: [GENERAL] Writing XML files to Operating System

Sure I will take care. Regards, Atul Goel -Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: 13 July 2010 13:26 To: Atul Goel Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Writing XML files to Operating System It's helpful if you can avoid replyin

[GENERAL] Writing XML files to Operating System

Atul Goel wrote: > > We are a data based company and are migrating from Oracle to > > Postgresql. For this purpose I am doing POC for the same. We have a > > business requirement to send the Data in XML files to our clients. > > The file size of XMLs is around 700MB and is growing. > > > >

[GENERAL] pl/pgsql editor and postgres developemnt tool

Hi All, I am looking for a good tool for pl/pgsql / postgres developemnt tool. Something like Toad for Oracle. Regards, Atul Goel SENIOR DEVELOPER Global DataPoint Middlesex House, 34-42 Cleveland Street London W1T 4LB, UK T: +44 (0)20 7079 4827 M: +44 (0)7846765098 www.globaldatapoint.com

Re: [GENERAL] pl/pgsql editor and postgres developemnt tool

Hi Ray, Thanks for reply. Are you using any editor for code formatting? Regards, Atul Goel -Original Message- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: 10 August 2010 10:30 To: Atul Goel Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pl/pgsql editor and postgres develo

[GENERAL] good exception handling archiecutre

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

Re: [GENERAL] good exception handling archiecutre

Hi Alban, Thanks for the reply. I checked that Notify will not work till the transaction is commited. So in our case since the transaction is being rolled back there will be no notify. I am new to Postgres so i am not sure how to run LISTEN as demon so that it keeps on running to be notified.

Re: [GENERAL] good exception handling archiecutre

Thanks Alban, I was able to do this using DBLINK. Thanks a lot for your help. Regards, Atul Goel -Original Message- From: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl] Sent: 16 August 2010 18:07 To: Atul Goel Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] good exce

Re: [GENERAL] good exception handling archiecutre

Hi VBI, DBLINK was a great idea. I have written the code to do that and it works perfectly. Regards, Atul Goel -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian von Bidder Sent: 16 August 2010 12:27 To: pgsql-ge

[GENERAL] IBATIS support for postgres cursors

Hi, Can cursors be returned to IBATIS. If so how. This is what I have written. This does not work. Please help. Regards, Atul Goel SENIOR DEVELOPER Global DataPoint Middlesex House, 34-42 Cleveland Street London W1T 4LB, UK T: +44 (0)20 7079 4827 M: +44

Re: [GENERAL] IBATIS support for postgres cursors

Hi Guy, Thanks for your reply. We were able to work out with type OTHER. Many thanks for support. Regards, Atul Goel -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Guy Rouillier Sent: 25 August 2010 08:03 To: pgsql-

[GENERAL] Kill -9 for a session process caused all the sessions to be killed

Hi All, I by mistake ran a query to update a huge table with around 50 rows and has to kill the session. I found the process-id from the query select * from pg_stat_activity. I killed the process using Kill -9 process_id. This caused all other sessions in the system to be killed and databa

Re: [GENERAL] Kill -9 for a session process caused all the sessions to be killed

Thanks Tom, I found the right way to kill the process. Regards, Atul Goel -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 22 September 2010 17:43 To: Atul Goel Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Kill -9 for a session process caused all the sessio