net._http_response rows do not respect TTL

[steve-chavez]

Problem

When having a TTL of:

show pg_net.ttl;

6 hours

Doing new requests succeed, but their response rows get deleted quickly(after 1 second):

select net.http_get('https://webhook.site/449fddab-5642-4645-9a5e-6c71f7fe9a8e'); 
select * from net._http_response;
-- 0 rows

This is because the worker inserts rows using a now() default value:

pg_net/src/worker.c

Lines 339 to 340 in 639b049

	appendStringInfo(&query_insert_response_ok, "\
	insert into net._http_response(id, status_code, content, headers, content_type, timed_out) values ($1, $2, $3, $4, $5, $6)");

pg_net/sql/pg_net.sql

Line 41 in 639b049

created timestamptz not null default now()

And this now() is not getting updated. Every new insert uses an "old" now() value.

Solution

Use SetCurrentStatementStartTimestamp() before:

pg_net/src/worker.c

Lines 205 to 206 in 639b049

	StartTransactionCommand();
	PushActiveSnapshot(GetTransactionSnapshot());

To make now() use the current time.