Send kea-dev mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.isc.org/mailman/listinfo/kea-dev
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of kea-dev digest..."
Today's Topics:
1. insert into dhcp4_subnet (Matt Zagrabelny)
----------------------------------------------------------------------
Message: 1
Date: Sat, 30 Sep 2023 06:18:41 -0500
From: Matt Zagrabelny <[email protected]>
To: [email protected]
Subject: [kea-dev] insert into dhcp4_subnet
Message-ID:
<CAOLfK3VZ9PDhWC5s3RCYNRKnhRrHgg9W9=h5g6vm3rxqjqx...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Greeting Kea Dev,
I'm attempting to insert a record into the dhcp4_subnet table, but am
hitting an error:
INSERT INTO dhcp4_subnet (
subnet_id,
subnet_prefix
)
VALUES (
10123,
'10.168.255.0/24'
);
ERROR: insert or update on table "dhcp4_audit" violates foreign key
constraint "fk_dhcp4_audit_revision"
DETAIL: Key (revision_id)=(0) is not present in table
"dhcp4_audit_revision".
CONTEXT: SQL statement "INSERT INTO dhcp4_audit (object_type, object_id,
modification_type, revision_id)
VALUES (object_type_val, object_id_val,
(SELECT id FROM modification WHERE modification_type =
modification_type_val),
audit_revision_id)"
PL/pgSQL function createauditentrydhcp4(character varying,bigint,character
varying) line 12 at SQL statement
SQL statement "SELECT createAuditEntryDHCP4('dhcp4_subnet', NEW.subnet_id,
'create')"
PL/pgSQL function func_dhcp4_subnet_ains() line 3 at PERFORM
Looking at the schema of the dhcp4_audit table makes me think I shouldn't
be manually manipulating the dhcp4_audit table.
Does anyone have an idea of what I'm doing wrong? or a successfully working
example of inserting a subnet into the dhcp4_subnet table?
Thanks for the help!
-m
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://lists.isc.org/pipermail/kea-dev/attachments/20230930/6215b8ff/attachment-0001.htm>
------------------------------
Subject: Digest Footer
_______________________________________________
kea-dev mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-dev
------------------------------
End of kea-dev Digest, Vol 87, Issue 3
**************************************
