On Fri, 17 Jan 2025 10:27:04 -0500
Tom Lane wrote:
> Kamen Kalchev writes:
> > Hi everyone, we're planning to upgrade the OS running Postgres from
> > ubuntu jammy to ubuntu noble. As part of the OS change, the glibc
> > version will be changed from glibc 2.35 to glibc 2.39..
> > Can someone con
On 1/18/25 06:04, Alexander Farber wrote:
Thank you Giovanni, I did not expect this from NOW() and that is why I
was stuck.
FYI, it is explained here:
https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
--
Adrian Klaver
adrian.kla...@aklaver.com
Thank you Giovanni, I did not expect this from NOW() and that is why I was
stuck.
I have decided to keep NOW() in my stored function in the hope it has
better performance.
To fix the issue I have rewritten my smoke tests to be plain SQL without
any transaction:
CREATE OR REPLACE FUNCTION test_st
Hi Alex,
On Sat, 18 Jan 2025 at 12:21, Alexander Farber
wrote:
> [...]
>
> -- Run 2 smoke tests
> DO $$
> DECLARE
> test_result RECORD;
> BEGIN
> -- Test 1: store 15x4 records expiring in 5 seconds
> SELECT * INTO test_result FROM test_store_vehicle_data(15);
> IF test_result.co
Hi fellow PostgreSQL users,
I have prepared a DB Fiddle https://dbfiddle.uk/BCXD_Bo2 for my question
and I will also show my complete SQL code below -
I am trying to store data in a vehicle_data table and each data record has
an expires_at column:
-- Create table for customer IDs
CREATE TABLE cu
