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
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
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
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 t
>>> 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 u
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 transactio
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 m
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
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 the
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 back.
10 matches
Mail list logo
