[Pdns-users] API Bug(?) with Postgres backend when inserting rr containg dots

[Peter van Dijk]

Hello Ferdinand,

On Tue, 2021-03-16 at 16:40 +0100, Ferdinand Goldmann via Pdns-users
wrote:
> Mar 16 15:48:10 **** pdns[67880]: [webserver] 759b42ae-4c22-42be-a961-6b27805d9171 HTTP ISE for "/api/v1/servers/localhost/zones/ferdl.test.": Exception: GSQLBackend unable to insert empty non-terminal rr 'name.ferdl.test' in domain_id 86: Fatal error during query: insert into records (type,domain_id,disabled,name,ordername,auth,ttl,prio,content) values (null,$1,false,$2,$3,$4,null,null,null): ERROR:  null value in column "type" violates not-null constraint DETAIL:  Failing row contains (4835479, 86, name.ferdl.test, null, null, null, null, f, null, t).

There is no NOT NULL constraint on records.type in the pgsql schema we
ship and document. Can you see if you somehow got a constraint into
your schema some other way?

Kind regards,
-- 
Peter van Dijk
PowerDNS.COM BV - https://www.powerdns.com/