[ic] Commiting changes to PGSQL products database -- edited items "disappear"

[NOW Website Coordinator]

Finally got all my tables into PGSQL by taking care of any weird NOT 
NULL/int fields.

I can search on the tables, and place an order.  These show up in the 
databases.

But I can't make changes that get committed to the items.  New items or 
edited items don't show up in scans or in the UI.  I can't see them if I do 
a "Limit with Search" in the UI.  Edited items that were just live on the 
site "disappear."

If I query on them (select * from products) they show up at the end of the 
table.  Is there some type of commit changes that needs to happen? (apply 
changes doesn't do it).  The permissions seem fine.

I am using version 4.9.6 on Linux.

Thanks for any help.