YQL-17353 YQL-17355 YQL-17357 YQL-17358 YQL-17360 YQL-17361 YQL-17362 more tables (mostly empty)

24 files changed, 486 insertions, 0 deletions

diff --git a/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp b/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp
index bd69c6ca75..84f03a737d 100644
--- a/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp
+++ b/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp
@@ -20,6 +20,7 @@
 #include <ydb/library/yql/utils/fp_bits.h>
 #include <library/cpp/yson/detail.h>
 #include <util/string/split.h>
+#include <util/system/getpid.h>
 
 #define TypeName PG_TypeName
 #define SortBy PG_SortBy
@@ -311,6 +312,14 @@ public:
             };
 
             ApplyFillers(AllPgShDescriptionFillers, Y_ARRAY_SIZE(AllPgShDescriptionFillers), PgShDescriptionFillers_);
+        } else if (Table_ == "pg_stat_gssapi") {
+            static const std::pair<const char*, TPgStatGssapiFiller> AllPgStatGssapiFillers[] = {
+                {"encrypted", []() { return ScalarDatumToPod(BoolGetDatum(false)); }},
+                {"gss_authenticated", []() { return ScalarDatumToPod(BoolGetDatum(false)); }},
+                {"pid", []() { return ScalarDatumToPod(Int32GetDatum(GetPID())); }}
+            };
+
+            ApplyFillers(AllPgStatGssapiFillers, Y_ARRAY_SIZE(AllPgStatGssapiFillers), PgStatGssapiFillers_);
         }
     }
 
@@ -371,6 +380,14 @@ public:
 
                 rows.emplace_back(row);
             }
+        } else if (Table_ == "pg_stat_gssapi") {
+            NUdf::TUnboxedValue* items;
+            auto row = compCtx.HolderFactory.CreateDirectArrayHolder(PgStatGssapiFillers_.size(), items);
+            for (ui32 i = 0; i < PgStatGssapiFillers_.size(); ++i) {
+                items[i] = PgStatGssapiFillers_[i]();
+            }
+
+            rows.emplace_back(row);
         }
 
         return compCtx.HolderFactory.VectorAsVectorHolder(std::move(rows));
@@ -392,6 +409,8 @@ private:
     TVector<TPgTablespaceFiller> PgTablespaceFillers_;
     using TPgShDescriptionFiller = NUdf::TUnboxedValuePod(*)(ui32 index);
     TVector<TPgShDescriptionFiller> PgShDescriptionFillers_;
+    using TPgStatGssapiFiller = NUdf::TUnboxedValuePod(*)();
+    TVector<TPgStatGssapiFiller> PgStatGssapiFillers_;
 };
 
 class TFunctionCallInfo {
diff --git a/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp b/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp
index 3df838928d..6e59c49d8c 100644
--- a/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp
+++ b/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp
@@ -115,6 +115,20 @@ public:
             FillPgTablespaceSchema(items, ctx);
         } else if (tableName == "pg_shdescription") {
             FillPgShDescriptionSchema(items, ctx);
+        } else if (tableName == "pg_trigger") {
+            FillPgTriggerSchema(items, ctx);
+        } else if (tableName == "pg_locks") {
+            FillPgLocksSchema(items, ctx);
+        } else if (tableName == "pg_stat_gssapi") {
+            FillPgStatGssapiSchema(items, ctx);
+        } else if (tableName == "pg_inherits") {
+            FillPgInheritsSchema(items, ctx);
+        } else if (tableName == "pg_stat_activity") {
+            FillPgStatActivitySchema(items, ctx);
+        } else if (tableName == "pg_timezone_names") {
+            FillPgTimezoneNamesSchema(items, ctx);
+        } else if (tableName == "pg_timezone_abbrevs") {
+            FillPgTimezoneAbbrevsSchema(items, ctx);
         } else {
             ctx.AddError(TIssue(ctx.GetPosition(input->Child(TPgReadTable::idx_Table)->Pos()), TStringBuilder() << "Unsupported table: " << tableName));
             return TStatus::Error;
@@ -174,6 +188,53 @@ private:
         AddColumn(items, ctx, "description", "text");
     }
 
+    void FillPgTriggerSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "tgrelid", "oid");
+        AddColumn(items, ctx, "tgenabled", "char");
+    }
+
+    void FillPgLocksSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "transactionid", "xid");
+    }
+
+    void FillPgStatGssapiSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "encrypted", "bool");
+        AddColumn(items, ctx, "gss_authenticated", "bool");
+        AddColumn(items, ctx, "pid", "int4");
+    }
+
+    void FillPgInheritsSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "inhrelid", "oid");
+        AddColumn(items, ctx, "inhparent", "oid");
+    }
+
+    void FillPgStatActivitySchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "application_name", "text");
+        AddColumn(items, ctx, "backend_start", "timestamptz");
+        AddColumn(items, ctx, "backend_type", "text");
+        AddColumn(items, ctx, "client_addr", "inet");
+        AddColumn(items, ctx, "datname", "name");
+        AddColumn(items, ctx, "pid", "int4");
+        AddColumn(items, ctx, "query", "text");
+        AddColumn(items, ctx, "query_start", "timestamptz");
+        AddColumn(items, ctx, "state", "text");
+        AddColumn(items, ctx, "state_change", "timestamptz");
+        AddColumn(items, ctx, "usename", "name");
+        AddColumn(items, ctx, "wait_event", "text");
+        AddColumn(items, ctx, "wait_event_type", "text");
+        AddColumn(items, ctx, "xact_start", "timestamptz");
+    }
+
+    void FillPgTimezoneNamesSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "name", "text");
+        AddColumn(items, ctx, "is_dst", "bool");
+    }
+
+    void FillPgTimezoneAbbrevsSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+        AddColumn(items, ctx, "abbrev", "text");
+        AddColumn(items, ctx, "is_dst", "bool");
+    }
+
     void AddColumn(TVector<const TItemExprType*>& items, TExprContext& ctx, const TString& name, const TString& type) {
         items.push_back(ctx.MakeType<TItemExprType>(name, ctx.MakeType<TPgExprType>(NPg::LookupType(type).TypeId)));
     }
diff --git a/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
index 77e7c93f82..3a0c982bbb 100644
--- a/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
@@ -2437,6 +2437,28 @@
         }
     ],
     "test.test[pg_catalog-pg_database-default.txt-Results]": [],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/81dfcdf279dd45758cc7cc418c3fe9b12f2e6066/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Debug]": [
+        {
+            "checksum": "5972890f7bfdda603cf4be92af2923c1",
+            "size": 2475,
+            "uri": "https://{canondata_backend}/1942525/81dfcdf279dd45758cc7cc418c3fe9b12f2e6066/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/81dfcdf279dd45758cc7cc418c3fe9b12f2e6066/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Results]": [],
     "test.test[produce-discard_process_with_lambda-default.txt-Analyze]": [
         {
             "checksum": "3bffa2a18b9b81cc1f89280482f926dc",
diff --git a/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
index 642ea2cfe8..abd77fb386 100644
--- a/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
@@ -2484,6 +2484,28 @@
         }
     ],
     "test.test[pg-tpch-q16-default.txt-Results]": [],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/253d2e760c7825837b0d53337823dd5ebf4d6d89/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Debug]": [
+        {
+            "checksum": "1c21cdfaefd86779f137aa70b1d0a294",
+            "size": 427,
+            "uri": "https://{canondata_backend}/1942525/253d2e760c7825837b0d53337823dd5ebf4d6d89/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/253d2e760c7825837b0d53337823dd5ebf4d6d89/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Results]": [],
     "test.test[produce-native_desc_reduce_with_presort--Analyze]": [
         {
             "checksum": "189853c55f2d9e624f216a137a95ae15",
diff --git a/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json
index 2ab59d9f5f..770eb93730 100644
--- a/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json
@@ -2369,6 +2369,28 @@
         }
     ],
     "test.test[pg-tpch-q21-default.txt-Results]": [],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/43a9b27bd71c75014ae789d65d577314e37262fc/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Debug]": [
+        {
+            "checksum": "e67d1f86d8fbe71065c2dd2113ffa254",
+            "size": 609,
+            "uri": "https://{canondata_backend}/1942525/43a9b27bd71c75014ae789d65d577314e37262fc/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/43a9b27bd71c75014ae789d65d577314e37262fc/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Results]": [],
     "test.test[sampling-mapjoin_right_sample-default.txt-Analyze]": [
         {
             "checksum": "87b97895afd9ac6a3350f69a77811ed1",
diff --git a/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
index 8d39e8f9b9..6de618ad86 100644
--- a/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
@@ -2047,6 +2047,28 @@
         }
     ],
     "test.test[pg-wide_top_sort--Results]": [],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1880306/c56e2bb8307f2239f8acf535a621c40b5a08a363/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Debug]": [
+        {
+            "checksum": "e2533b4d21ac0d1b5ff40de375f82edb",
+            "size": 423,
+            "uri": "https://{canondata_backend}/1880306/c56e2bb8307f2239f8acf535a621c40b5a08a363/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1880306/c56e2bb8307f2239f8acf535a621c40b5a08a363/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Results]": [],
     "test.test[pragma-classic_division-default.txt-Analyze]": [
         {
             "checksum": "a48ccc9922567dfee1170d2c2df45b6e",
diff --git a/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json
index a63a133381..6e6018b751 100644
--- a/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json
@@ -2147,6 +2147,28 @@
         }
     ],
     "test.test[pg-tpcds-q89-default.txt-Results]": [],
+    "test.test[pg_catalog-pg_trigger-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1936947/d814cd457b003ee9da1e09ee0877a39078a61012/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_trigger-default.txt-Debug]": [
+        {
+            "checksum": "a9343f2f2090854546fd4e0631d01829",
+            "size": 422,
+            "uri": "https://{canondata_backend}/1936947/d814cd457b003ee9da1e09ee0877a39078a61012/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_trigger-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1936947/d814cd457b003ee9da1e09ee0877a39078a61012/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_trigger-default.txt-Results]": [],
     "test.test[produce-discard_reduce_lambda-default.txt-Analyze]": [
         {
             "checksum": "c87ac713fed1eacadd4720a18695a0fc",
diff --git a/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
index 53f543ac44..b709e15356 100644
--- a/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
@@ -2288,6 +2288,28 @@
         }
     ],
     "test.test[pg-type_aliases-default.txt-Results]": [],
+    "test.test[pg_catalog-pg_inherits-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1937429/82c91013a516db34237d53cdad4ae5a77a3c568b/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_inherits-default.txt-Debug]": [
+        {
+            "checksum": "156e0c70e953deb093778c2ee37a139c",
+            "size": 424,
+            "uri": "https://{canondata_backend}/1937429/82c91013a516db34237d53cdad4ae5a77a3c568b/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_inherits-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1937429/82c91013a516db34237d53cdad4ae5a77a3c568b/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_inherits-default.txt-Results]": [],
     "test.test[pg_catalog-pg_tablespace-default.txt-Analyze]": [
         {
             "checksum": "c1f2d837c3623c81dd596a9877913fb8",
diff --git a/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
index 2344ae1ad7..ca216ca53b 100644
--- a/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
@@ -2507,6 +2507,28 @@
         }
     ],
     "test.test[pg-tpch-q01-default.txt-Results]": [],
+    "test.test[pg_catalog-pg_locks-default.txt-Analyze]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/795fb6df3f52b9e4c9442c13b6e21f3c55c8e287/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Analyze_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_locks-default.txt-Debug]": [
+        {
+            "checksum": "cf4254fa5a235519234177b99bda9228",
+            "size": 413,
+            "uri": "https://{canondata_backend}/1942525/795fb6df3f52b9e4c9442c13b6e21f3c55c8e287/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Debug_/opt.yql_patched"
+        }
+    ],
+    "test.test[pg_catalog-pg_locks-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1942525/795fb6df3f52b9e4c9442c13b6e21f3c55c8e287/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_locks-default.txt-Results]": [],
     "test.test[sampling-bind_expr-default.txt-Analyze]": [
         {
             "checksum": "48c500323490b6c607e4a54b8382169a",
diff --git a/ydb/library/yql/tests/sql/sql2yql/canondata/result.json b/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
index ec2735de86..d17a95167c 100644
--- a/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
+++ b/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
@@ -13068,6 +13068,20 @@
             "uri": "https://{canondata_backend}/1942525/b1770d18f4fe73123c8ba7b8888beae32aa4e70b/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_database_/sql.yql"
         }
     ],
+    "test_sql2yql.test[pg_catalog-pg_inherits]": [
+        {
+            "checksum": "9e2b5f69bd2bc691faba1a97058d4358",
+            "size": 718,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_inherits_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[pg_catalog-pg_locks]": [
+        {
+            "checksum": "4e58e80b4fb31d4bbfb3a1e777cf8d0b",
+            "size": 647,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_locks_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[pg_catalog-pg_shdescription]": [
         {
             "checksum": "3c2389e9a1d831db2944939e11919590",
@@ -13075,6 +13089,20 @@
             "uri": "https://{canondata_backend}/1937424/e8964bf325e3789f68bbeb40e42daa75bf189e76/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_shdescription_/sql.yql"
         }
     ],
+    "test_sql2yql.test[pg_catalog-pg_stat_activity]": [
+        {
+            "checksum": "817fe9904a476a06a4f8ac70719863c5",
+            "size": 1652,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_stat_activity_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[pg_catalog-pg_stat_gssapi]": [
+        {
+            "checksum": "618acd0a4c833faffdb13606ed680142",
+            "size": 1241,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_stat_gssapi_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[pg_catalog-pg_tablespace]": [
         {
             "checksum": "755687f11614cdbe84381134ddba275c",
@@ -13082,6 +13110,27 @@
             "uri": "https://{canondata_backend}/1777230/5b7a099a288bb49a0012caf8ab53daf90cc81178/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_tablespace_/sql.yql"
         }
     ],
+    "test_sql2yql.test[pg_catalog-pg_timezone_abbrevs]": [
+        {
+            "checksum": "819b8051c278e97b81db1eb14bd8e77a",
+            "size": 724,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_timezone_abbrevs_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[pg_catalog-pg_timezone_names]": [
+        {
+            "checksum": "c92b180256ced2b5c782f04cffbf0034",
+            "size": 716,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_timezone_names_/sql.yql"
+        }
+    ],
+    "test_sql2yql.test[pg_catalog-pg_trigger]": [
+        {
+            "checksum": "7e442f9f1b41a976a45c4f7cea2ca500",
+            "size": 714,
+            "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_trigger_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[pg_catalog-pg_type_syntax_pg]": [
         {
             "checksum": "46b77fc59cdf4578c9766bb551960a56",
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql
new file mode 100644
index 0000000000..28e7c1c6ef
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+inhrelid,
+inhparent
+from 
+pg_catalog.pg_inherits
\ No newline at end of file
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql
new file mode 100644
index 0000000000..b827421b7c
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select
+transactionid
+from
+pg_catalog.pg_locks
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql
new file mode 100644
index 0000000000..04ddde2e1d
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql
@@ -0,0 +1,18 @@
+--!syntax_pg
+select
+application_name,
+backend_start,
+backend_type,
+client_addr,
+datname,
+pid,
+query,
+query_start,
+state,
+state_change,
+usename,
+wait_event,
+wait_event_type,
+xact_start
+from
+pg_catalog.pg_stat_activity
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql
new file mode 100644
index 0000000000..a25e2f09e7
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql
@@ -0,0 +1,9 @@
+--!syntax_pg
+select count(*),min(encrypted::text),min(gss_authenticated::text) from (
+select 
+encrypted,
+gss_authenticated,
+pid
+from 
+pg_catalog.pg_stat_gssapi
+) a
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql
new file mode 100644
index 0000000000..08348b1a26
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+abbrev,
+is_dst
+from 
+pg_catalog.pg_timezone_abbrevs
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql
new file mode 100644
index 0000000000..1fc53cfa1c
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+name,
+is_dst
+from 
+pg_catalog.pg_timezone_names
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql
new file mode 100644
index 0000000000..26a3c4eeb3
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+tgrelid,
+tgenabled
+from
+pg_catalog.pg_trigger
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
index d708c3e233..696ea5ee80 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
@@ -2162,6 +2162,27 @@
             "uri": "https://{canondata_backend}/1942671/52a125a1bb7634ddba0f986b6cf8177f5b9c01df/resource.tar.gz#test.test_pg_catalog-pg_database-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Debug]": [
+        {
+            "checksum": "5f0ef35ef92a98a0cf2883b9073a790d",
+            "size": 2413,
+            "uri": "https://{canondata_backend}/1880306/5bf16e2167c9f8e2e17b8a7f36952412023a8f4c/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1880306/5bf16e2167c9f8e2e17b8a7f36952412023a8f4c/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_gssapi-default.txt-Results]": [
+        {
+            "checksum": "1ec59fb2239388502a1fb8ac236ec631",
+            "size": 1250,
+            "uri": "https://{canondata_backend}/1880306/5bf16e2167c9f8e2e17b8a7f36952412023a8f4c/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[produce-discard_process_with_lambda-default.txt-Debug]": [
         {
             "checksum": "27942941f86ed34cf249b81dea07228c",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
index 7e0b61d477..b884533ad8 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
@@ -2325,6 +2325,27 @@
             "uri": "https://{canondata_backend}/1942415/14c2050022adcb6379d90c4a2a09abf0847e7643/resource.tar.gz#test.test_pg-tpch-q16-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Debug]": [
+        {
+            "checksum": "e983e9f6127c869fa931803e046a636b",
+            "size": 371,
+            "uri": "https://{canondata_backend}/1784117/6c74bc79d1e176324c55e10f093a69211469bf8f/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1784117/6c74bc79d1e176324c55e10f093a69211469bf8f/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Results]": [
+        {
+            "checksum": "05b66aa78dd526e74f646515a24a7f76",
+            "size": 832,
+            "uri": "https://{canondata_backend}/1784117/6c74bc79d1e176324c55e10f093a69211469bf8f/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[pragma-release_temp_data_chain_pull_fail--Debug]": [],
     "test.test[pragma-release_temp_data_chain_pull_fail--Plan]": [],
     "test.test[pragma-release_temp_data_chain_pull_fail--Results]": [],
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json
index 2dc63fd06d..bb2f8284f0 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json
@@ -2307,6 +2307,27 @@
             "uri": "https://{canondata_backend}/1923547/5154c8bd8ef9ead4f609771f831f20c15e795571/resource.tar.gz#test.test_pg-tpch-q21-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Debug]": [
+        {
+            "checksum": "b59897b13cb9d2ae72ae4b532c4d110e",
+            "size": 553,
+            "uri": "https://{canondata_backend}/1880306/1ee788a2569716571a36649ae2ceeb626ced8876/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1880306/1ee788a2569716571a36649ae2ceeb626ced8876/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_stat_activity-default.txt-Results]": [
+        {
+            "checksum": "3a28eeeb833c250eb13c14d612d57c3e",
+            "size": 4033,
+            "uri": "https://{canondata_backend}/1880306/1ee788a2569716571a36649ae2ceeb626ced8876/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[produce-process_rows_sorted_desc_multi_out--Debug]": [
         {
             "checksum": "202fbb809a2ada2cd5905af79fdf20b0",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
index 49037d9e6f..bf55549e6f 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
@@ -1737,6 +1737,27 @@
             "uri": "https://{canondata_backend}/1923547/68f2fa8e051f31489bd496c183d28c4abddf9f68/resource.tar.gz#test.test_pg-wide_top_sort--Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Debug]": [
+        {
+            "checksum": "9556fc60b3df570c33b659d305caabb8",
+            "size": 367,
+            "uri": "https://{canondata_backend}/1773845/62fef1198b24b563ccf204edcd5c1495d1dd9b02/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1773845/62fef1198b24b563ccf204edcd5c1495d1dd9b02/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_timezone_names-default.txt-Results]": [
+        {
+            "checksum": "7f3512f1840d703239beb47aac672601",
+            "size": 830,
+            "uri": "https://{canondata_backend}/1773845/62fef1198b24b563ccf204edcd5c1495d1dd9b02/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[pragma-classic_division-default.txt-Debug]": [
         {
             "checksum": "1bb9103519440102fad6e4a51ff73fa5",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json
index e36b60e964..bc2a1e0654 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json
@@ -1821,6 +1821,27 @@
             "uri": "https://{canondata_backend}/1937027/67f47e98bc150e7387e3e30adedc957caafe9c32/resource.tar.gz#test.test_pg-tpcds-q89-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_trigger-default.txt-Debug]": [
+        {
+            "checksum": "0dba33788a6b6bef7fb67c22841aad2d",
+            "size": 366,
+            "uri": "https://{canondata_backend}/1775319/059e812ace6b1d28f72605b86d16778e7d38747a/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_trigger-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1775319/059e812ace6b1d28f72605b86d16778e7d38747a/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_trigger-default.txt-Results]": [
+        {
+            "checksum": "4aa02cda56dad43828e73fc66f8775ea",
+            "size": 835,
+            "uri": "https://{canondata_backend}/1775319/059e812ace6b1d28f72605b86d16778e7d38747a/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[produce-discard_reduce_lambda-default.txt-Debug]": [
         {
             "checksum": "776f33da0611fa0335effb3dc55b0563",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
index 21eede358b..876f6ad966 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
@@ -2020,6 +2020,27 @@
             "uri": "https://{canondata_backend}/1937027/16b7289b1b8f5fdff728155d836fa2b238949b2d/resource.tar.gz#test.test_pg-type_aliases-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_inherits-default.txt-Debug]": [
+        {
+            "checksum": "04b3f618fafbd2d61b06703d4c961238",
+            "size": 368,
+            "uri": "https://{canondata_backend}/1880306/1b2ed13cc159ed80cf548a266f7c691ac03de80a/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_inherits-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1880306/1b2ed13cc159ed80cf548a266f7c691ac03de80a/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_inherits-default.txt-Results]": [
+        {
+            "checksum": "dc5a6d27d606a4c9ca0b88781855e5bc",
+            "size": 835,
+            "uri": "https://{canondata_backend}/1880306/1b2ed13cc159ed80cf548a266f7c691ac03de80a/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[pg_catalog-pg_tablespace-default.txt-Debug]": [
         {
             "checksum": "50b49b7d45a6d6b53f4dc30d689a3ea9",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
index c345b6fc1c..597bea026b 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
@@ -2233,6 +2233,27 @@
             "uri": "https://{canondata_backend}/937458/6ac3198834a310678c10f517fcfbcfc2838fc3af/resource.tar.gz#test.test_pg-tpch-q01-default.txt-Results_/results.txt"
         }
     ],
+    "test.test[pg_catalog-pg_locks-default.txt-Debug]": [
+        {
+            "checksum": "0990fef4d925f5683cc1e368a81ba936",
+            "size": 357,
+            "uri": "https://{canondata_backend}/1936947/a37065cef418c774590fd5acbf7693d8c77bccaa/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Debug_/opt.yql"
+        }
+    ],
+    "test.test[pg_catalog-pg_locks-default.txt-Plan]": [
+        {
+            "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+            "size": 948,
+            "uri": "https://{canondata_backend}/1936947/a37065cef418c774590fd5acbf7693d8c77bccaa/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Plan_/plan.txt"
+        }
+    ],
+    "test.test[pg_catalog-pg_locks-default.txt-Results]": [
+        {
+            "checksum": "67cdcb90b5e7a0d243a7d5e660b9ce71",
+            "size": 578,
+            "uri": "https://{canondata_backend}/1936947/a37065cef418c774590fd5acbf7693d8c77bccaa/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Results_/results.txt"
+        }
+    ],
     "test.test[pragma-release_temp_data_chain_pull_single_thread--Debug]": [
         {
             "checksum": "280c47bff6a833450a7b1d127fb06423",