From: | postgresql_contributors <postgresql_contributors(at)newtglobalcorp(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Kiran Suresh Kulkarni <kirans(at)newtglobalcorp(dot)com>, Hari Prasad B <hariprsadb(at)newtglobalcorp(dot)com> |
Subject: | Guidance Needed for Testing PostgreSQL Patch (CF-5044) |
Date: | 2024-12-04 08:07:15 |
Message-ID: | TYZPR03MB816867F0BAAE37EF3445B89DE1372@TYZPR03MB8168.apcprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi pg_hackers,
I hope you are doing well. I am working on reviewing PostgreSQL community tickets and started with the patch cf/5044.
This patch is in the branch cf/5044, and I pulled the code to test it.
Here’s what I have done so far:
*
Pulled the code from the branch cf/5044.
*
Compiled the code.
*
Set up the database as required.
Tested the query for this patch mentioned in the community chat (https://commitfest.postgresql.org/50/5044/) .
However, I didn’t get the expected output mentioned in the ticket (below mentioned example).
CREATE TABLE foo3(id serial PRIMARY key, txt text);
INSERT INTO foo3 (txt) VALUES ('aaa'),('bbb');
DO $$
DECLARE
l_cnt int;
BEGIN
l_cnt := 1
DELETE FROM foo3 WHERE id=1;
END; $$
-- without reaction - just don't work
(2024-06-16 16:05:55) postgres=# set plpgsql.extra_errors to
'strict_expr_check';
SET
(2024-06-16 16:06:43) postgres=# DO $$
DECLARE
l_cnt int;
BEGIN
l_cnt := 1
DELETE FROM foo3 WHERE id=1;
END; $$;
ERROR: syntax error at or near "DELETE"
LINE 11: DELETE FROM foo3 WHERE id=1;
^
Please provide guidance on this patch.
Thanks and Regards,
Postgresql Contributors - Newt Global
[cid:6feaaeb6-762b-426b-9ada-c03243768529]
Newt Global India Pvt. Ltd.
SSPDL Alpha City , Gamma Block,
25, Rajiv Gandhi Salai (OMR),
Navalur, Chennai - 600130 .
From | Date | Subject | |
---|---|---|---|
Next Message | jian he | 2024-12-04 08:10:20 | Re: NOT ENFORCED constraint feature |
Previous Message | Heikki Linnakangas | 2024-12-04 07:55:43 | Re: Remove remnants of "snapshot too old" |