Re: [GENERAL] 9.5 - Is there any way to disable automatic rollback?

2016-04-11 Thread Marc Mamin
Hello, if you are using pgjdbc, there is a discussion about adding an option to modify this behavior: https://github.com/pgjdbc/pgjdbc/issues/423 This would simplify the migration of java projects, e.g. from oracle to postgres. regards, Marc Mamin From:

Re: [GENERAL] 9.5 - Is there any way to disable automatic rollback?

2016-04-11 Thread Durumdara
Dear All! >In PG it's seems to be different. PG silently rollback the actual > transaction. >> > > I am not seeing silent: > ERROR: current transaction is aborted, commands ignored until end of > transaction block > I say "silently", because first I didn't recognize that all things lost, not

Re: [GENERAL] How to build docs from master?

2016-04-11 Thread Andreas Joseph Krogh
På mandag 11. april 2016 kl. 15:05:06, skrev Artur Zakirov < a.zaki...@postgrespro.ru >: On 11.04.2016 15:27, Andreas Joseph Krogh wrote: > Hi all. > I have installed PG (master) from git, but it seems the docs are not > built issuing "make install". Yes. You

Re: [GENERAL] How to build docs from master?

2016-04-11 Thread Artur Zakirov
On 11.04.2016 15:27, Andreas Joseph Krogh wrote: Hi all. I have installed PG (master) from git, but it seems the docs are not built issuing "make install". Yes. You need to run "make world" to build everything or "make docs" to build docs. And run "make install-world" to install everything or

Re: [GENERAL] Really unique session ID - PID + connection timestamp?

2016-04-11 Thread Durumdara
Dear All! 2016-04-10 18:03 GMT+02:00 Adrian Klaver : > On 04/10/2016 06:29 AM, durumd...@gmail.com wrote: > >> >> Products, offers are edited for long time. >> > > Define long time, a session, a day, days, etc? > For 1 minute to 1-2 hours. > > But we must save

[GENERAL] How to build docs from master?

2016-04-11 Thread Andreas Joseph Krogh
Hi all.   I have installed PG (master) from git, but it seems the docs are not built issuing "make install". I've tried "make docs" but it fails with:     interface Makefile:127: recipe for target 'HTML.index' failed make[3]: *** [HTML.index] Error 1 make[3]: Leaving directory

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

2016-04-11 Thread Stephen Frost
* Albe Laurenz (laurenz.a...@wien.gv.at) wrote: > Marllius wrote: > > OCFS2 = oracle cluster file system 2 > > I think using OCFS2 for PostgreSQL data is a good idea if you want > to be the first at something or try to discover bugs in OCFS2. I've found that OCFS2 is a very decent clustered

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

2016-04-11 Thread Marllius
Thanks guys, the answers helped me a lot in my decision , I'm evaluating my options.

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

2016-04-11 Thread John R Pierce
On 4/8/2016 6:16 AM, Marllius wrote: thank you, but i need a link in official postgresql documentation as postgresql is operating system independent, its pretty unlikely there will be discussions of specific file systems in the official documentation. -- john r pierce, recycling bits in

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

2016-04-11 Thread Albe Laurenz
Marllius wrote: > OCFS2 = oracle cluster file system 2 I think using OCFS2 for PostgreSQL data is a good idea if you want to be the first at something or try to discover bugs in OCFS2. Why do you want a cluster file system for PostgreSQL? You cannot have more than one server access the same