Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

insert a row with a primary key that uses a sequence?

April 26, 2017insert key primary row sequence uses

0

Posted

insert a row with a primary key that uses a sequence?

1 Answer

0

Posted

You need to create a trigger in your database that updates your primary key field from the sequence. To help PK::Auto find your inserted key, you can tell it the name of the sequence in the column_info supplied with add_columns.