Skip site navigation (1) Skip section navigation (2)

Re: Help with DELETE statement via ODBC

From: Håkon Clausen <hakonhc(at)nospam(dot)hclausen(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Help with DELETE statement via ODBC
Date: 2004-06-07 08:03:36
Message-ID: opr87soaoy1y0472@news.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Carlos,

This is the correct behavior. Deleting 0 rows will give an ODBC error.
You will have to rewrite your query so that this does not occur.

Håkon


On Mon, 31 May 2004 19:19:16 +0200, Carlos Abalde <carlos(at)lfcia(dot)org> wrote:

> Hi!
>
> I've been all the day fighting against a DB access poblem, and I'm
> sure that the problem is related with the ODBC postgresql driver,
> but I don't know how to solve it.
>
> The problem is that when I execute a DELETE stament over a indetifier
> not found in a table, the driver returns an error instead of a counter
> with 0 rows affected. I'm using the last version of the driver.
>
> Any idea? Best regards,
>
> +---.---.---.---.---.---.---.---.---+---.---.---.---.---.---.---.---+
> | Carlos Abalde (carlos(at)lfcia(dot)org)  | http://www.lfcia.org/~carlos  |
> + LFCIA Lab, Dept. Computer Science | +34.981.167000 ext. 1275      +
> | University of A Coruna, Spain     | PGP Key ID = 0x04DF0EAF       |
> +-.---.---.---.---.---.---.---.---.-+-.---.---.---.---.---.---.---.-+
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

In response to

Responses

pgsql-odbc by date

Next:From: Carlos AbaldeDate: 2004-06-07 20:13:41
Subject: Re: Help with DELETE statement via ODBC
Previous:From: Shachar ShemeshDate: 2004-06-07 05:15:10
Subject: [Fwd: [SECURITY] [DSA 516-1] New odbc-postgresql packages fix denial of service]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group