Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyTxe-0009J7-2z for pgsql-novice@arkaria.postgresql.org; Fri, 06 Mar 2026 12:07:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyTxc-004sMv-1F for pgsql-novice@arkaria.postgresql.org; Fri, 06 Mar 2026 12:07:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyTxb-004sMe-2p for pgsql-novice@lists.postgresql.org; Fri, 06 Mar 2026 12:07:16 +0000 Received: from mx2.alte-leipziger.de ([91.217.145.232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vyTxY-00000000lbx-3PAM for pgsql-novice@lists.postgresql.org; Fri, 06 Mar 2026 12:07:15 +0000 X-CSE-ConnectionGUID: f4hfU1H3Q6a8pU504V+TVw== X-CSE-MsgGUID: Ijj0RRa1QP6KV9ZAUs8DBg== From: "Subramanian,Ramachandran" To: "pgsql-novice@lists.postgresql.org" Subject: SQL - How to iterate with delay in a loop Thread-Topic: SQL - How to iterate with delay in a loop Thread-Index: AdytYTn1S3tW22UjQaaujhAZjcHBDQ== Date: Fri, 6 Mar 2026 12:07:05 +0000 Message-ID: <6c2c6ae6d61a467a91d08414e38b50c5@alte-leipziger.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: cd4bo9JS5DQRz9YLdsFULH0tCKdnhB58Wyp9qNukZ1BvTOI9YAS51j4C ii3pSpSYJaQokcGSq+gsEFWH07Y1pf1N8S9tF60fwsybRluqYXpk9EiT3DtQkOUH2+bY0IGE x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--5.490600-8.000000 x-tm-snts-smtp: 23C08980C01A411E4B50A34BD3AA52556E96DBEA8C756526433842F861A43DBD2000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_6c2c6ae6d61a467a91d08414e38b50c5alteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: Fwr9X//Hq0ilpTqmaFOcoi6mpjSuqVpOF9rBbwI5lEt3zvB1Fg4zwrxu4nB0KF78 X-GBS-PROCJOB: =?utf-8?Q?AbcdLESZYf0iNpKoty7qUwQS5j5h0SP8MvUYMw7qk1If+mkPUM9+S/CPJdzp?= =?utf-8?Q?zSVPNoldlytOLr1pY1wiV9UXgM7fvWxtPZqzi8Svy5qTrkM/NCRDoNYphF0J?= =?utf-8?Q?pATK6VppJwcHanMkzj1j5MEK911eeRuwN9YcW0JNSbPD5YyRYlU=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_6c2c6ae6d61a467a91d08414e38b50c5alteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am trying to insert some rows into a table with a delay between each = insert. I have a simple table with a ID column and some Date-Time columns= . The first two inserts work as expected and insert two rows, each one seco= nd apart. However the do loop inserts 25 more rows, with the same timestamp. I am completely new to Postgres and may have overlooked something simple. I would be grateful for your help. LG Ram drop table time_zone_demo; create table time_zone_demo ( ID_COLUMN SERIAL PRIMARY KEY, SAVED_TS_NO_TZ TIMESTAMP, SAVED_TS_WITH_TZ TIMESTAMPTZ, SAVED_DATE DATE, SAVED_TIME TIME ); Insert into time_zone_demo (SAVED_TS_NO_TZ,SAVED_TS_WITH_TZ,SAVED_DATE,SA= VED_TIME) values (now(),now(),current_date,current_time) ; select pg_sleep(1); Insert into time_zone_demo (SAVED_TS_NO_TZ,SAVED_TS_WITH_TZ,SAVED_DATE,SA= VED_TIME) values (now(),now(),current_date,current_time) ; select pg_sleep(1); do $$ begin for rec in 1..25 loop perform pg_sleep(1); Insert into time_zone_demo (SAVED_TS_NO_TZ,SAVED_TS_WITH_TZ,S= AVED_DATE,SAVED_TIME) values (now(),now(),current_date,current_time) ; end loop; end; $$; Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Obe= rursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 =20 Hallesche Krankenversicherung a.G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 Nr. 5 VersStG) =B7 Versicherungsle= istungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigkeiten = sind umsatzsteuerfrei =20 =20 Die Pflichtangaben der ALH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 Akt= G finden Sie hier: https://www.alte-leipziger.de/impressum=20 ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de --_000_6c2c6ae6d61a467a91d08414e38b50c5alteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

  I am trying to insert some rows into a = table with a delay between each insert. I have a simple table with a ID c= olumn and some Date-Time columns.

 

The first two inserts work as expected and ins= ert two rows, each one second apart.

 

However the do loop inserts 25 more rows, with= the same timestamp.

 

I am completely new to Postgres and may have o= verlooked something simple.

 

I would be grateful for your help.

 

 

LG

 

Ram

 

 

drop table time_zone_demo;

create table time_zone_demo<= /p>

(

  ID_COLUMN SERIAL PRIMARY KEY,

  SAVED_TS_NO_TZ TIMESTAMP,

  SAVED_TS_WITH_TZ TIMESTAMPTZ,

  SAVED_DATE DATE,

  SAVED_TIME TIME

);

 

Insert into time_zone_demo (SAVED_TS_NO_TZ,SAV= ED_TS_WITH_TZ,SAVED_DATE,SAVED_TIME)

values (now(),now(),current_date,current_time)= ;

 

select pg_sleep(1);

 

Insert into time_zone_demo (SAVED_TS_NO_TZ,SAV= ED_TS_WITH_TZ,SAVED_DATE,SAVED_TIME)

values (now(),now(),current_date,current_time)= ;

 

select pg_sleep(1);

 

do $$

begin

        for= rec in 1..25

       &nbs= p;    loop

       &nbs= p;    perform pg_sleep(1);

       &nbs= p;    Insert into time_zone_demo (SAVED_TS_NO_TZ,SAVED_TS_= WITH_TZ,SAVED_DATE,SAVED_TIME)

       &nbs= p;    values (now(),now(),current_date,current_time) ;

       &nbs= p;    end loop;

end;

$$;


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversich= erung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsra= ts: Dr. Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrg= en Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexand= er Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 = Rechtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-Id= Nr. DE 114106814


Hallesche Krankenversicherun= g a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr.= Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bier= baum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Maye= r, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsfor= m VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285

Beitr=E4ge zu privaten Krank= en- und Pflegekrankenversicherungen unterliegen nicht der Versicherungste= uer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4t= ze aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei<= /SPAN>


= Pflichtangaben der A= LH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_6c2c6ae6d61a467a91d08414e38b50c5alteleipzigerde_--