Results 1 to 2 of 2

Thread: New added postgresql table rows appears with delay

  1. #1
    Join Date
    Mar 2011
    Posts
    14
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default New added postgresql table rows appears with delay

    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?

  2. #2
    Join Date
    May 2012
    Posts
    136
    Thanks
    2
    Thanked 27 Times in 24 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    Unix/X11 Windows

    Default Re: New added postgresql table rows appears with delay

    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?

Similar Threads

  1. Replies: 4
    Last Post: 10th May 2011, 12:19
  2. Replies: 1
    Last Post: 28th October 2010, 22:36
  3. Replies: 2
    Last Post: 25th January 2010, 20:56
  4. Postgresql QSqlRelationalTableModel empty table
    By RolandHughes in forum Qt Programming
    Replies: 0
    Last Post: 12th November 2008, 17:18
  5. Replies: 1
    Last Post: 24th July 2008, 18:20

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.