detecting transaction results? - Mailing list pgsql-novice

From James Hartley
Subject detecting transaction results?
Date
Msg-id AANLkTikQGb8FjErcqHOCRBJ8BVLm4xYGYBgN=ZnpsmUz@mail.gmail.com
Whole thread Raw
List pgsql-novice
In looking at the discussion in Section 3.4 of the 8.4.4 Documentation on transactions, it appears that it is meant to be transparent.  If the transaction succeeds, it succeeds.  If it doesn't, it is rolled back.  Yet is there anyway to determine if the transaction succeeded or not after the fact?  I am writing a cron which depends upon multiple files being accessed through ftp.  I would like to store the results in a table, but this is dependent upon whether all files were successfully read or not.

Thanks for any insight anyone would care to share.

Jim

pgsql-novice by date:

Previous
From: Thomas Uzunoff
Date:
Subject: Re: PostgreSQL article online - PDF
Next
From: Lukasz Brodziak
Date:
Subject: Changing column datatype without droping views