Re: Transaction Aborted

I think that the feature you're looking for is a SAVEPOINT.

After the import, create a savepoint, and then if the user makes a typo
revert to that savepoint.

Regards,Jeff Davis

On Sun, 2005-02-20 at 22:05 -0500, Edwin S. Ramirez wrote:
> Hello,
> 
>     This may sound familiar since there was a discussion before...
> 
> I created an importing tool which allows users to load data into their 
> tables using a graphical interface.
> The import operations occur within a transaction so that the user gets a 
> chance to change their mind.
> After the import is finished the user is presented with a choice to 
> "abort", "commit" or interact with the
> database.  Interacting with the database allows the user to submit 
> queries to verify the data load.
> 
> Everything works great except that if the user makes any typos the 
> entire transaction is aborted,
> requiring the import process to be done again.
> 
> I was under the impression that the nested transaction feature would 
> make this go away. 
> I played a little with it and it seems that the entire transaction is 
> aborted even if a checkpoint is
> created.
> 
> Could someone please help me with this?
> 
> -Thanks,
> Edwin S. Ramirez
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly