POSIX shell & Postgre Error capturing

[dragonbite]

@martin_helm

Am 14.08.2012 17:36, schrieb dragonbite:
> Using “\set ON_ERROR_STOP TRUE” is working and returning the error

Now I have a quick question back, which version of Postgres is that?
The \set did not do the job for me (but maybe I was simply too tired and
made a typo and got it right in the -v option of psql - easily possible
and the most likely explanation).

But just to be sure mine is 9.1.3, what’s yours?

–
PC: oS 12.2 x86_64 | i7-2600@3.40GHz | 16GB | KDE 4.8.4 | GeForce GT 420
ThinkPad E320: oS 12.1 x86_64 | i3@2.30GHz | 8GB | KDE 4.8.5 | HD 3000
eCAFE 800: oS 12.1 i586 | AMD Geode LX 800@500MHz | 512MB | KDE 3.5.10

PostgreSQL 8.4.8 on FreeBSD 8.2

Seems this is a change I should definitely put into place, since it doesn’t work on your newer version and some time in the future we’re going to be upgrading the system.