resilient transactions - PostgreSQL Database

Paramveer.Singh

Hi all!
Apologies for sending this mail but some time back there was a thread on
supporting resilient transactions - i.e. transactions which do not roll
back if one query in 100 fails.
This was thought to be useful in case someone is typing on the psql prompt
and makes a spelling mistake. I would like to know what was the result of
that thread.
I tried searching in postgres-general but could not find it.
Can anyone point out the link to me?

thanks a lot
paramveer singh

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1

Subscribe Reply

1039

Jeff

On Sep 7, 2004, at 3:35 AM, Pa************* @trilogy.com wrote:

Hi all!
Apologies for sending this mail but some time back there was a thread
on
supporting resilient transactions - i.e. transactions which do not roll
back if one query in 100 fails.

transactions can either entirely succeed or entirely fail, there is no
"sometimes" . Any discussion or even patches that do change that will
be rejected immediately (Well, I'm simply assuming they will. I think
myself and many others would be mighty surprised if a patch like that
got applied!)

PG 8.0 introduces a feature called savepoints which allows you to trap
errors inside a transaction (and also rollback parts of the
transaction, etc.) You may want to look into that.

http://developer.postgresql.org/docs...savepoint.html

--
Jeff Trout <je**@jefftrout .com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

Similar topics

2387

Seeking Testing Volunteers W2K MTS/DTC to VMS DECdtm Distributed 2PC Transactions

by: Richard Maher | last post by:

Hi, I am seeking the help of volunteers to test some software that I've developed which facilitates distributed two-phase commit transactions, encompassing any resource manager (e.g. SQL/Server or Oracle) controlled by Microsoft's Distributed Transaction Coordinator in a Windows2000 environment, with any resource manager under the control of DECdtm (e.g. Rdb (or Oracle via the XA Veneer)) in a VMS environment.

Microsoft SQL Server

393

transactions

by: Iain Mcleod | last post by:

I wish to do a series of inserts on a sql server database in the context of a transaction. The inserts will be done as a series of stored procedure calls. I wish to be able to rollback any inserts should one fail. A quick google on ".net transactions" and the following page comes up: http://samples.gotdotnet.com/quickstart/aspplus/doc/mtstransactions.aspx It says basically that the class System.EnterpriseServices.ContextUtil is the...

.NET Framework

2805

Group and sum transactions for last year in which a transaction exists

by: Terri | last post by:

I have a table called Transactions with 3 fields: ID, Date, and Amount. Each ID can have multiple transactions in one particular year. An ID might not have had any transactions in recent years. For each ID I would like to sum all the transactions for the most recent year in which one or more transactions have occurred. Thanks for any help and for all previous help.

Microsoft Access / VBA

2069

Having trouble setting up transactions

by: TD | last post by:

I am trying to add transactions to my code. The original code worked fine until I followed an example to setup transactions, now the code does strange things, but no error messages. Could someone please review my before and after code and tell me the proper way to add transactions to my code? Thanks, TD

Microsoft Access / VBA

13004

C# transactions v SQL transactions

by: Mike P | last post by:

I've been using C# transactions for a while and had no problems with them. Using try catch blocks I can trap basically all possible errors and rollback all necessary data. Over the last few days I've been trying to convert some of this code to SQL Server stored procedures, but it seems to lack many of the benefits of C# transactions - a lot of the errors don't seem to be trapped by the SQL error trapping (e.g. if I do an update on a row...

C# / C Sharp

1411

Transactions / JBoss -- similar Microsoft tool?

by: mark | last post by:

In Java, you can use JBoss or similar to host EJB that will manage your transactions for you. You could, of course, write your own transactions using JDBC. In .NET, we can specify our own transactions using ADO.NET. Is there a compatible tool within .NET to JBoss, where the transactions are managed for you? Thanks in advance. Mark

C# / C Sharp

1345

Problem in Selecting Closed Transactions

by: radcaesar | last post by:

Customer Table ID Name Address City Phone 1 Vijay Stores 6,Gandhi Road Pondy 0413-276564 2 Ram Stores 3, MG Road, Pondicherry 0413-29543756 3 Balu Papers 3, RG St, Neyveli +919366228639 4 Senthil Papers 3, JN Road Cuddalore 04142-287654 6 TEst PRT PRT 246246 7 xxxx ggg eryyty drggd

Microsoft Access / VBA

2703

implementing sql transactions in data access layers

by: Sridhar | last post by:

Hi, I am trying to implement sql transactions. But I am not knowing how to do that. I created a data access layer which contains methods to select/insert/update tables in a database. I have also created a business logic layer to retrieve/update the data from the data access layer. All of this is working fine if there are no transactions involved. If I need to use transactions, I am not knowing how to do that. Lets say I have a webform...

ASP.NET

2046

Transactions and Locking

by: Rami | last post by:

I have some requirement for an automated payment system. The system has four machines setup as follows: 1- Two machines have a clustered database. 2- Two machines have a .net business logic component that will handle payment transactions with certain external component (Payment Gateway) My query is regarding transaction handling inside the business logic component. Because this component is running on two machines and these two...

.NET Framework

9728

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10648

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10389

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9205

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7670

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6890

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4339

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3867

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3018

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General