Re: libpq prepared statement insert null for foreign key

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ted Toth <txtoth(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: libpq prepared statement insert null for foreign key
Date: 2020-03-10 00:06:02
Message-ID: 8346ce59-d007-a3f9-6ad4-c197ba3d393e@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/9/20 5:00 PM, Ted Toth wrote:
> I tries setting the parameter for the foreign NULL:
> params[i] = NULL;

I think you will need to show the code previous to the above.

>
> 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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sonam Sharma 2020-03-10 06:53:49 V9.5
Previous Message Ted Toth 2020-03-10 00:00:51 libpq prepared statement insert null for foreign key