Postgres Pro
Downloads
Home   >   mailing lists

Re: Rollback on include error in psql - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Rollback on include error in psql
Date
Msg-id CANu8FiwR_qpk2=FY2HasdG6QXNMj2cbzxdTjiaXX++nFpif5Fg@mail.gmail.com
Whole thread Raw
In response to Rollback on include error in psql  (Viktor Shitkovskiy <hanksmail@gmail.com>)
Responses Re: Rollback on include error in psql
List pgsql-general
Tree view
You did not show the complete script.
Did you remember to start the "transaction" with BEGIN; and end with COMMIT;?
eg:
BEGIN;
\include ../tables/table1.cre
\include ../tables/table2.cre
...
\include ../tables/table10.cre
COMMIT;


On Sun, Dec 28, 2014 at 3:02 AM, Viktor Shitkovskiy <hanksmail@gmail.com> wrote:
Hello.

I'm trying to execute an sql script file in a single transation. The file contains includes for some other scripts which in my example create some tables. It looks like this:
    \include ../tables/table1.cre
    \include ../tables/table2.cre
    ...
    \include ../tables/table10.cre

I'm executing it using psql:
    psql -X --set AUTOCOMMIT=off --set ON_ERROR_STOP=on -e --single-transaction -d my_db -f my_script.sql

The problem is that errors with the include meta command do not cause a transactiopn rollback. e.g. if some of tableX.cre files is missing, any changes before its include will be commited. However, if there's some SQL syntax error, everyting works as expected.

Is it possible to somehow handle include related errors and rollback the active transcation?

I'm using PostgreSQL 9.2.1.




--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Arup Rakshit
Date:
Subject: Re: HINT: Perhaps you need a different "datestyle" setting - postgresql
Next
From: Adrian Klaver
Date:
Subject: Re: Rollback on include error in psql