libpq prepared statement insert null for foreign key

From: Ted Toth <txtoth(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: libpq prepared statement insert null for foreign key
Date: 2020-03-10 00:00:51
Message-ID: CAFPpqQGz7Rk6Nwh-vD2iHdnERz_sOJkV+Z1UxQxTupJfhzq8UA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I tries setting the parameter for the foreign NULL:
params[i] = NULL;

and I get a 'Key not present in table ...' error. How do I insert a record
where I don't have a foreign key yet?

Ted

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-03-10 00:06:02 Re: libpq prepared statement insert null for foreign key
Previous Message Adrian Klaver 2020-03-09 19:44:37 Re: gdal version for Postgis 2.4?