I am brand new to pgsql... J I have a VB program inserting records into a fairly simple table (without a PK) and I notice that when the table is empty I get a "row out of range" error. This only happens when the table is empty. If I insert a record from psql then run the program everything is fine. Any ideas as to what may be wrong?
I am using ADO to connect and recordset.addnew / recordset.update to insert records.