PDA

View Full Version : New added postgresql table rows appears with delay



nickla
5th June 2012, 08:50
I try to add row to table in postgresql. After i execute INSERT command using QSqlQuery, i can not retieve this new row. It appears after 20-30 second delay.

If i add row in my table and try to see this row in PgAdmin, i will see it here. I tried to add, stop my server, start it and my row appeared with 20-30 second delay.


There is no such delay with other tables in this database.

I can not find why this is happened. It seems that postgresql decided not to show new row only in this table for Qt connections.

Can anybody help me with this?

StrikeByte
5th June 2012, 12:07
Do you stop the server just after adding the row? If so maybe the insert is not yet finished when stopping the server
Why do you want to stop the server?

Can you post your code?