Andrus,

I would not use append from and insert each row.

select mytable
scan 
  scatter memver memo 
  ?m.pk
  insert into newrecords from memvar
  skip in mytable 
endscan 

>I need to add records to a table in PostgreSQL server .
>
>I ceated a SPT cursor mytable and made it updatable.
>It has row buffering enabled. VFP sends each row as separate INSERT command to backend.
>
>I use the following code to add records to sql server:
>
>

SELECT mytable
>APPEND FROM dbf('newrecords')

>
>Some record violates referential integrity and this causes error
>in APPEND FROM line
>
>Connectivity error: ERROR: insert or update on table
>"mytable" violates foreign key constraint "mytable_customer_fkey"
>
>How to determine the record in newrecords table which causes this error ?
>Which is best way to add many record so that the row caused error can be determined ?