Dear all,
I'm having a problem with transactions and exceptions and need your advice.
I want a function to do two things:
- log something to a table (which is basically an insert)
- raise an exception under certain conditions
My problem is that when I raise the exception the insert is rolled
Bart Degryse wrote:
Dear all,
I'm having a problem with transactions and exceptions and need your advice.
I want a function to do two things:
- log something to a table (which is basically an insert)
- raise an exception under certain conditions
My problem is that when I raise the exception
I have a bunch of application programs written in C++ that use Embedded SQL.
This have been working for many years with IBM's DB2.
I am about to upgrade my Red Hat Enterprise Linux 3 system to RHEL 5, and I
would like to use postgresql instead of DB2. I cannot find an authoritative
statement that
On Jun 22, 3:25 am, earthwormgaz [EMAIL PROTECTED] wrote:
hello, i'm trying to do a simple (so i thought) sql insert operation,
but i'm being told the insert violates unique constraint
say i've got three columns, two text and one integer for the id, i'm
doing the following
INSERT INTO myTable
Richard Huxton [EMAIL PROTECTED] 2007-06-22 15:24
Bart Degryse wrote:
Dear all,
I'm having a problem with transactions and exceptions and need your advice.
I want a function to do two things:
- log something to a table (which is basically an insert)
- raise an exception under certain
Bart Degryse wrote:
2. Using dblink / dbi-link to reconnect to the database, which means
your logging will take place in its own transaction.
This I like more. Though I don't use either dblink nor dbi-link, I do use this kind of
'double' connections already for other purposes in which
Tom Lane wrote:
Jean-David Beyer [EMAIL PROTECTED] writes:
What is the current status of (pre) compiling Embedded SQL in C++ programs?
I just asked Michael Meskes about that (had you put a support request
into Red Hat asking this?).
Yes, and Red Hat's answer amounted to no answer at all.
Jean-David Beyer [EMAIL PROTECTED] writes:
What is the current status of (pre) compiling Embedded SQL in C++ programs?
I just asked Michael Meskes about that (had you put a support request
into Red Hat asking this?). He says
: There are some C++ constructs that ecpg doesn't parse well, but
On Friday 22 June 2007 12:23, Alexandre Parizot wrote:
Wei, Can you check the database error messages in the message Main
Log. You can find the system information in the email System Info 7.1.
Alex.
This is the script that caused the error in 7.1.0.0. (Fixed already)
The script in CVS is
On Thu, 21 Jun 2007 14:46:49 -0300
Ranieri Mazili [EMAIL PROTECTED] wrote:
Hi,
I noticed that if DIV_MES = 0 (= NULL) then the previous query
didn't go well. I rewrite the query. It's including a check statement
to replace NULL with 1.
At first, you need to create a table of months.
--
Masaru
10 matches
Mail list logo