INSERT malfunction between MS-Access - PostgreSQL - LO

Can anyone help me identify the source of following misbehavior and correct it?

I'm test how MS-Access handles large objects (LO) when using linked
tables that are mapped to the OLE Object datatype.

When I insert a new record, the record always returns with a #Deleted.
When I close the form and refresh, the record displays.

I checked the PostgreSQL logs generated after an insert to see why I
getting #Deleted. Here is what I saw:

2009-10-23 08:31:06 PDTLOG: statement: BEGIN
2009-10-23 08:31:06 PDTLOG: fastpath function call: "lo_creat" (OID 957)
2009-10-23 08:31:06 PDTLOG: fastpath function call: "lo_open" (OID 952)
2009-10-23 08:31:06 PDTLOG: fastpath function call: "lo_lseek" (OID 956)
2009-10-23 08:31:06 PDTLOG: fastpath function call: "lowrite" (OID 955)
2009-10-23 08:31:06 PDTLOG: fastpath function call: "lowrite" (OID 955)

.... [ then hundreds repeats of the previous log]

2009-10-23 08:31:09 PDTLOG: fastpath function call: "lowrite" (OID 955)
2009-10-23 08:31:09 PDTLOG: fastpath function call: "lo_close" (OID 953)
2009-10-23 08:31:09 PDTLOG: statement: INSERT INTO
"public"."testtable" ("object") VALUES ('48509'::lo)
2009-10-23 08:31:09 PDTLOG: statement: SELECT "id","object","xmin"
FROM "public"."testtable" WHERE "id" IS NULL
2009-10-23 08:31:09 PDTLOG: statement: COMMIT
2009-10-23 08:31:09 PDTLOG: statement: SELECT "id","object","xmin"
FROM "public"."testtable" WHERE "id" IS NULL


For some reason, a record is being selected with id IS NULL, rather
than selecting the next id. Is there anyway to correct this behavior?

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc