Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qImIJ-0003Jj-R4 for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 08:30:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qImII-0007xf-OE for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 08:30:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qImFX-0001nj-3Z for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 08:28:03 +0000 Received: from smtp37.i.mail.ru ([95.163.41.78]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qImFT-0032NK-HR for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 08:28:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru; s=mail4; h=Subject:From:To:MIME-Version:Date:Message-ID:Content-Type:From:Subject:Content-Type:Content-Transfer-Encoding:To:Cc; bh=EXjv14GqJ+T/ByyRPboH0knUHrHYDZV0W0gNlnZLqNo=; t=1688977679;x=1689067679; b=GWNAQH3KmERl2xUtpfWRIZbs13ZxTrVy6ljkn1fBW2XeBAUjjTgdnmw//eCdIpWGfx86VvFSFG7jNyJwKGATURv5aFDCAg1ik/iEQpiexUxlqdj00obdm/vvoqCm7EDcjV+2QY5p6LYXDF/F0VnMMP4VTzxEwKOHWtbmcLeCH4bcmOMTFsw2/WUKRDZ1DcQxqyzERlDHOst3fOYm3poo75OIKwrxCFFBqtCt4Grfxp1Bf2aWhHoInlBYL6MuoD41SJRWQ0fHIgQ8460T8s3wMX82TOfnXCqsOpZvDHwoSe/KTacPSiO6C9cMjfPR853u5Q6jvbFkiJFAYWiNJ++hiQ==; Received: by smtp37.i.mail.ru with esmtpa (envelope-from ) id 1qImFP-003olb-RT for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 11:27:56 +0300 Content-Type: multipart/alternative; boundary="------------xqtW66CKbl8qp5q1vWQhxnnB" Message-ID: Date: Mon, 10 Jul 2023 10:27:55 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 To: pgsql-general@lists.postgresql.org From: =?UTF-8?Q?Andr=c3=a9_Kutepow?= Subject: search_path for replica-mode Authentication-Results: smtp37.i.mail.ru; auth=pass smtp.auth=isaev.mail@mail.ru smtp.mailfrom=isaev.mail@mail.ru X-Mailru-Src: smtp X-7564579A: 646B95376F6C166E X-77F55803: 4F1203BC0FB41BD9F6142ABD4516DDC568A6520FCE9965AB3D0633B1DAE4E7F6182A05F5380850406D4B6013F528702D74C821FD7757E9CF7A50019A5E2A311AB817C6C0A3AFF943 X-7FA49CB5: FF5795518A3D127A4AD6D5ED66289B5278DA827A17800CE7F5B0FEFE70B13B25EA1F7E6F0F101C67BD4B6F7A4D31EC0BCC500DACC3FED6E28638F802B75D45FF8AA50765F7900637CF19945FAF91394A8638F802B75D45FF36EB9D2243A4F8B5A6FCA7DBDB1FC311F39EFFDF887939037866D6147AF826D85FD9FB7713206774EF9516ABCBF7ABB86F9789CCF6C18C3F8528715B7D10C86878DA827A17800CE73AFA331E307B52169FA2833FD35BB23D9E625A9149C048EE33AC447995A7AD18E5D25F19253116ADD2E47CDBA5A96583BD4B6F7A4D31EC0BC014FD901B82EE079FA2833FD35BB23D27C277FBC8AE2E8B89C3E995CBB71A93A471835C12D1D977C4224003CC836476EB9C4185024447017B076A6E789B0E975F5C1EE8F4F765FCB3005CC78FE6A91F3AA81AA40904B5D9CF19DD082D7633A0C84D3B47A649675F3AA81AA40904B5D98AA50765F790063760A376DC6F02B751D81D268191BDAD3D3666184CF4C3C14F3FC91FA280E0CE3D1A620F70A64A45A98AA50765F7900637A451E1E29F2EDBED6D1867E19FE1407959CC434672EE6371089D37D7C0E48F6C8AA50765F7900637217F7D133B16D230EFF80C71ABB335746BA297DBC24807EABDAD6C7F3747799A X-C1DE0DAB: 0D63561A33F958A5B56046A71497014F29A7CF130E5B506CBE5017FAB067B70FF87CCE6106E1FC07E67D4AC08A07B9B0A6C7FFFE744CA7FB9C5DF10A05D560A950611B66E3DA6D700B0A020F03D25A0997E3FB2386030E77 X-C8649E89: 1C3962B70DF3F0ADBF74143AD284FC7177DD89D51EBB7742DC8270968E61249B1004E42C50DC4CA955A7F0CF078B5EC49A30900B95165D346B222596F62B8FA9F29AFE97842AF85F2CA2822B2D8437B434D421DE587AAD3F179E4FF0908DB82C1D7E09C32AA3244C04E5CAA10FA80B26397558474EF60ED2F165894D92D62706BC4AF6B5DE6957CB5DA084F8E80FEBD3B0C9A30C56DC56681A9C9EB37C1779FD37E69C174A41D00C X-D57D3AED: 3ZO7eAau8CL7WIMRKs4sN3D3tLDjz0dLbV79QFUyzQ2Ujvy7cMT6pYYqY16iZVKkSc3dCLJ7zSJH7+u4VD18S7Vl4ZUrpaVfd2+vE6kuoey4m4VkSEu530nj6fImhcD4MUrOEAnl0W826KZ9Q+tr5ycPtXkTV4k65bRjmOUUP8cvGozZ33TWg5HZplvhhXbhDGzqmQDTd6OAevLeAnq3Ra9uf7zvY2zzsIhlcp/Y7m53TZgf2aB4JOg4gkr2biojbL9S8ysBdXgIVs/uPPEnYkbPVCNbZ3Qu X-Mailru-Sender: CD4900A89C0C9EA9549DF361C9DDCC1ADE7EB583A4C9085A28727D36EE429E66628B432787154A74F514894B45277BEDC77752E0C033A69E2266609A2CF35BD8B09203103E403AE5B4A721A3011E896F X-Mras: Ok List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------xqtW66CKbl8qp5q1vWQhxnnB Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit There is a trigger in the database SET search_path TO "$user", public; CREATE OR REPLACE FUNCTION art__a_iu_func() BEGIN   INSERT INTO table_z...   --//»table_z« is in schema public// END; CREATE OR REPLACE TRIGGER art__a_iu     AFTER INSERT OR UPDATE OF ak_nr     ON art     FOR EACH ROW     EXECUTE FUNCTION art__a_iu_func(); In a regular trigger, it works great! But, if I announce it, as: ALTER TABLE art ENABLE REPLICA TRIGGER art__a_iu; then I get an error: /FEHLER:  Relation »table_z« existiert nicht bei Zeichen xxx// //ANFRAGE:  INSERT INTO table_z... /why does'nt work the search_path for replica-mode? is it made specifically or is it a bug? How else can I set the search_path for replica-mode? --------------xqtW66CKbl8qp5q1vWQhxnnB Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit There is a trigger in the database
SET search_path TO "$user", public;

CREATE OR REPLACE FUNCTION art__a_iu_func()
BEGIN
  INSERT INTO table_z...   --»table_z« is in schema public
END;

CREATE OR REPLACE TRIGGER art__a_iu
    AFTER INSERT OR UPDATE OF ak_nr
    ON art
    FOR EACH ROW
    EXECUTE FUNCTION art__a_iu_func();
In a regular trigger, it works great!
But, if I announce it, as:
ALTER TABLE art ENABLE REPLICA TRIGGER art__a_iu;
then I get an error:
FEHLER:  Relation »table_z« existiert nicht bei Zeichen xxx
ANFRAGE:  INSERT INTO table_z...

why does'nt work the search_path for replica-mode?
is it made specifically or is it a bug?
How else can I set the search_path for replica-mode?

--------------xqtW66CKbl8qp5q1vWQhxnnB--