472,145 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid

Hi All,

I have a very weird problem which is occurring with a VB.Net app and
PostgreSQL 7.3.1. There is a form that has a standard .Net datagrid on it
that contains some data from a table in PostgreSQL.

Now, the datagrid has functionality to allow the developer to
programmatically determine what changes (if any) that have been made to the
grid by the user -- i.e. determine if any new rows has been added, any rows
modified or deleted.

These changes are then written back into the database by simply calling an
update function on a DataAdapter object.

Now here's the problem.....the application is working fine for a couple of
months with all inserts, updates and deletes carried out on the database
table without any problems. Now updates do not work with the dataAdapter
update where a 'DBConcurrencyException' is thrown -- i.e. the dataAdapter
object will check that the underlying row(s) to be updated (in the database)
have not been changed since the dataGrid was populated with the data. This
you can imagine, can be an issue if there are a number of users working on
the same data / form, however, I am getting this problem with only *ONE*
user. This problem seems to be isolated to a particular table as I have had
no problems with any of the other datagrids in the application that perform
insert / update / delete operations.

The bizarre thing is that if I backup the database, drop it, and recreate it
from the backup, then the application works fine again.....what is up with

This lead me to think it may have been a maintenance thing, so I tried to
VACUUM-ANALYZE the table in question, but that has had no effect.

Does anyone have any thoughts, suggestions?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #1
0 1693

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jeffrey Melloy | last post: by
13 posts views Thread by Dmitry Tkach | last post: by
reply views Thread by shamila | last post: by
reply views Thread by Alejandro Penate-Diaz | last post: by
7 posts views Thread by scorpion53061 | last post: by
1 post views Thread by Marco | last post: by
2 posts views Thread by Flack | last post: by
reply views Thread by berry | last post: by
reply views Thread by RossGK | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.