Odp: Aggregate function problem in VB6

Hi,
This is Postgres logfile:

DEBUG: StartTransactionCommand
DEBUG: query: SELECT SUM(field) FROM table
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand

Log seems ok to me but still SUM() doesn't work on VB side.

Regards,
Przemek Wieclawek

----- Original Message -----
From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Sekcja Informatyki Medycznej <informatyka(at)cskmswia(dot)pl>
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Sent: Friday, June 01, 2001 4:16 AM
Subject: Re: [ODBC] Aggregate function problem in VB6

> Sekcja Informatyki Medycznej wrote:
> >
> > Hi,
> > I have encountered a problem with following query run over ODBC in MS VS
6.0
> > SP5 in DataEnvironment designer:
> >
> > "SELECT SUM(field1) FROM table1;"
> > field 1 is of type INT4.
> >
> > There is "E_FAIL" error message.
> >
>
> Could you see the server-side log ?
> Try running the postmaster with -d2 (and without -S)
> and see what gets logged in its stderr output.
>
> regards,
> Hiroshi Inoue
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>