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

BUG #4695: update bug

From: "carl" <carl(at)multimax(dot)co(dot)za>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4695: update bug
Date: 2009-03-06 13:24:54
Message-ID: 200903061324.n26DOsVQ073722@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4695
Logged by:          carl
Email address:      carl(at)multimax(dot)co(dot)za
PostgreSQL version: 8.3
Operating system:   windows
Description:        update bug
Details: 

Hi, I'm running on asp.net 3.5

When running the following code, a number representing the number of
effected rows is returned, but the database entries have not been changed.

The following is written in c# code.

Please could you help me, as I've been struggling with this issue for over a
month now, and cannot figure out why it's not working...

=============
Code Snippet
=============
NpgsqlConnection L_Conn = Get_PostgresConnection(SystemCode);

DataSet ds = new DataSet();
NpgsqlDataAdapter da = new NpgsqlDataAdapter(Qry, L_Conn);
                    
da.Fill(ds);

ds.Tables[0].Rows[0]["sys_code"] = "try";

DataSet ds2 = ds.GetChanges();

NpgsqlCommandBuilder L_CmndBuilder = new NpgsqlCommandBuilder(da);
                    
return da.Update(ds2);

(returns 1 as it should)

pgsql-bugs by date

Next:From: carlDate: 2009-03-06 13:25:44
Subject: BUG #4696: update bug
Previous:From: Jaime CasanovaDate: 2009-03-05 20:37:22
Subject: Re: [HACKERS] Re: BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite

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