Re: [GENERAL] many sql file and one transaction

2011-10-18 Thread salah jubeh
October 18, 2011 3:23 PM Subject: Re: [GENERAL] many sql file and one transaction On Tue, Oct 18, 2011 at 7:57 AM, Cédric Villemain wrote: > 2011/10/18 salah jubeh : >> Hello, >> Thanks for the reply. >> I considered  cat as an option but I did not go for it, because of the &

Re: [GENERAL] many sql file and one transaction

2011-10-18 Thread Merlin Moncure
; Regards >> >> >> >> >> >> >> From: "andr...@a-kretschmer.de" >> To: salah jubeh >> Sent: Tuesday, October 18, 2011 2:23 PM >> Subject: Re: [GENERAL] many sql file and one transaction >> &g

Re: [GENERAL] many sql file and one transaction

2011-10-18 Thread Cédric Villemain
salah jubeh > Sent: Tuesday, October 18, 2011 2:23 PM > Subject: Re: [GENERAL] many sql file and one transaction > > > Zitat von salah jubeh : > >> Hello, >> >> >> I have many SQL script files to update schema, delete data, unit >> test etc.  I want to

Re: [GENERAL] many sql file and one transaction

2011-10-18 Thread salah jubeh
causing the error. Regards     From: "andr...@a-kretschmer.de" To: salah jubeh Sent: Tuesday, October 18, 2011 2:23 PM Subject: Re: [GENERAL] many sql file and one transaction Zitat von salah jubeh : > Hello, > > > I have ma

Re: [GENERAL] many sql file and one transaction

2011-10-18 Thread Alban Hertroys
On 18 October 2011 14:11, salah jubeh wrote: > Hello, > > I have many SQL script files to update schema, delete data, unit test > etc.  I want to run all the files in one transaction using shell script > to ease the installation procedure. I can do that from the psql client by > using the \i o

[GENERAL] many sql file and one transaction

2011-10-18 Thread salah jubeh
Hello, I have many SQL script files to update schema, delete data, unit test etc.  I want to run all the files in one transaction using shell script to ease the installation procedure. I can do that from the psql client by using the \i option BEGIN; \i  / .../ module1.sql \i  / .../