By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,691 Members | 2,041 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,691 IT Pros & Developers. It's quick & easy.

Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid

P: n/a
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
that!?!?

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?
TIA
-simon

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

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.